a surprisingly good water effect for a licensed PS2 game from 2004

a surprisingly good water effect for a licensed PS2 game from 2004

How did they make it look so good?