We've probably sat on every seat in this ride, and have never gotten more than a few sprinkles.  But sometimes the seats and hand pads are a little wet and smell of mildew (yuck).  If this would still bother him, I'd suggest draping a poncho over him for the the ride (and under his bottom on the seat).  I think you can even find the one-use ponchos at the dollar store.