Hey, sorry to butt in here! I noticed this is a recurring question – it has to do with the fact that the Water Material is only used for terrain datasets that are delivered as quantized-mesh.
The water mask is delivered as metadata in quantized-mesh that Cesium for Unreal can consume in a material layer. Google Photorealistic 3D Tiles does not contain an equivalent (yet!).