When applying water or any liquid appearance to a material in Realistic view, it shows as a translucent solid.
Since Realistic view has been upgraded to be more realistic, water should also show up in a rendered quality similar to how it appears in Ray-trace mode in Revit 2020.