If it's good enough for us to eat or drink them, then it's good enough for the fish.
This is false. Copper for example at the level allowed in drinking water in North America is safe for humans but deadly to all fish in an aquarium. Same holds for chlorine.
Nitrates above 10 ppm in drinking water is known to cause birth defects when this water is consumed by pregnant women, and is considered a health risk for children; which is why there are limits in NA.
Fish physiology and mammal physiology is vastly different. What is in the water significantly affects fish more than other animals just drinking it.
Some citations from a paper published by Cornell University will debunk some of the myths.
https://psep.cce.cornell.edu/facts-slides-self/facts/nit-heef-grw85.aspx
Water with nitrate levels below the health standard usually supplies an almost negligible percentage of an adult's nitrate intake. Eighty to 90 percent of the nitrate most people consume comes from vegetables, but this is unlikely to cause health problems because very little of the nitrate in vegetables is converted to nitrite. Meat products account for less than 10 percent of nitrate in the diet, but 60 to 90 percent of the nitrite consumed. This is primarily because of sodium nitrite added to foods such as hot dogs, bacon, or ham. Fruits, grains, and dairy products contribute almost no nitrate or nitrite to people's diets.
Nitrate in drinking water is measured either in terms of the amount of nitrogen present or in terms of both nitrogen and oxygen. The federal standard for nitrate in drinking water is 10 milligrams per liter (10 mg/l) nitrate-N, or 45 mg/l nitrate-NO3. when the oxygen is measured as well as the nitrogen. Unless otherwise specified, nitrate levels usually refer only to the amount of nitrogen present, and the usual standard, therefore, is 10 mg/l.
Short-term exposure to drinking water with a nitrate level at or just above the health standard of 10 mg/l nitrate-N is a potential health problem primarily for infants. Babies consume large quantities of water relative to their body weight, especially if water is used to mix powdered or concentrated formulas or juices. Also, their immature digestive systems are more likely than adult digestive tracts to allow the reduction of nitrate to nitrite. In particular, the presence of nitrite in the digestive tract of newborns can lead to a disease called methemoglobinemia.