The new hide water feature on prims only hides the surface of water. So if you go under the water level, even if you are inside a water hiding prim, you will see the underwater fog. I hope you can update this in the future so we can make underwater structures where the interior is not foggy while inside a water hiding prim.