Aside from the drop, there's nothing scary about Splash Mountain (and even that is over relatively quickly!). The rest of it is fairly calm, although there's a small drop or two - nothing at all severe. The rest finds you floating through some unique and really incredibly rendered settings.