Cats are not afraid of water. But if your survival depended on having no scent in the thick fur covering your body, you would also avoid getting wet— you would avoid it like the very plague it could be equivalent to. So yes, even for domestic house cats, this is a biological, evolutionary reason for avoiding water.