Well, it's too bad that the imagineers didn't produce a ride that adults would like. Fantasyland at Disney World shouldn't target the kid audience apparently.
Really people, you are complaining about a ride that is supposed to produce a smile on kid's faces and transport them to that world. It wasn't designed to be Expedition Everest.
Also, it's a dark ride that has been imagineered in the Disney tradition. If you look at the other dark rides in the Magic Kingdom it's easily #1 or #2, maybe only behind Pirates. Definitely better than Peter Pan, Haunted Mansion, Pooh, IASW, and Splash. This was not designed as an E ticket attraction.
As for my opinion of it, and I'm a 44 year old father of two teen daughters, I love the ride. Very fun and upbeat, and the Ursula animatronic is amazing. Love the music and all the details, if you look for them. It's a great dark ride.