I wanted to add that we took DS on Journey to Imagination when he was 3 months old and he loved that one. He didn't freak out with the noise, the lights, or even the part where they blow wind on you.
It really depends on the child and you are who knows yours best. If at home they don't like loud noise, then they probably won't be comfortable with it on vacation.
If you are comfortable with it, and it's feasible on the ride, you can always just cover the baby's ears with your hands if you know you are expecting a loud part.