Most cats have an aversion to water, so I’ve never understood their fondness for fish.
They may be averse to water, but I had a cat that used to go fishing in the fish tank I had. She left the goldfish and other species alone. EXCEPT for the Plecostomus. She ate at least five of them until I put a cover over the tank she couldn’t dislodge.