I rode this ride on Wednesday and Saturday and I never saw any water effects. I didn't even know there was any until I came here. However I have to say that the ride is still pretty epic without them. The only major problem I saw was yesterday, the screen with the goblin that tells you where to hide wasn't working correctly. I think only the right projector was working or something because the left eye was just a black screen.
I had the same problem with the goblin scene in my two rides yesterday. Got a re-ride due to no sound in the 2nd to last scene; then we heard that audio in the finale scene, it was bizarre.