I'd argue it's possibly the most thrilling attraction in the park. I know adults who will ride BTMR and Space but not Splash, out of fear for that drop.
It'll be interesting to see what the ride's sensibility and target demographic actually turn out to be. PATF is a film very much aimed toward children, but much of the promotional material for TBA (the acronym we'll now be using for Tiana's Bayou Adventure, lol) has emphasized celebrating New Orleans and black culture and Mardi Gras, indicating this may be more of an everyone/family attraction and less princess and children-oriented than I initially assumed.