I have no doubt that the Clean Water Act has been super effective at cleaning up water. I do think that environmental protections have been significantly damaged, and that if we do not yet see those effects on water, like we currently do for air, then it's likely that water quality will soon decline.

There was a huge change in the 70s, but those changes are currently being rolled back.