I was on the newly opened POTC on Saturday and didn't get wet at all. Well, there may have been a couple of mist droplets but nothing to make clothes wet. And we were sitting in the very front next to the CM.
That said <Spoiler Alert?>
There were many places where it looks like you will get drenched, and are told you may get wet, but then the boat turns or the critter stops spraying, etc. It was a pretty amusing ride for my young kids. But our CM was super cheesy which got a bit annoying after a while.
Hope this helps!