I know the question is specifically about hard/soft water, but PH has a big part to play, certainly in 'natural' water. PH doesnt always follow the law of nature with tap water as water companies supplement soft water with bicarb to raise the PH, in a bid to prevent pipe corrosion from what would otherwise have been soft, and therefore acidic water.
I'm not going to pretend to understand the majority of this:
Ionic regulation and acid–base balance are fundamental to the physiology of vertebrates including fish. Acidification of freshwater ecosystems is recognized as a global environmental problem, and the physiological responses to acid exposure in a few fish species are well characterized. However...
jeb.biologists.org
but it is evident that theres a decline in fish due to a decrease in PH in natural waters (acid rain).
From what I gather, this is partly due to the make up of fish gills (see ionocytes). The gills of fish who
are adapted to acidic/soft water, don't 'work as hard' as fish who are not adapted to acidic/soft water. The gills of non-acidic dwelling fish develop more mucus, the gill structure deteriorates, and eventually the fish suffocates.
Thanks for asking the question
@FishFinatic77 , some interesting reading afoot!