I absolutely love Splash Mt. It is one of the highlights of my trip. My kids love it too! (8,8,12,14) They've been going on this ride for several years now. My dh doesn't do this ride because of his back.
As mentioned above, the ride is very tame and gets a little wilder as you go. The last drop is not as bad as it looks to people watching on the bridge. You do get some very cool views of the park (especially at night) from the ride.