I think the water looks pretty real. In real life, water can look very different depending on the amount of waves, the depth, time of day, angle of view, etc.
This water looks like a realistic very calm lake. The only thing it doesn't have (yet) is interaction with the scenery objects - especially the kraken animatronic. But I do notice how the scenery gradually disappears below the surface like in real life.
Hopefully, there will be variations in the water. More waves and ripples in larger bodies of water or with increasing wind from weather. Also, maybe the option for how "clear" the water is since in some water you can barely see below the surface, yet some other water is super clear and you can see many feet below.