It's not necessarily to do with the health of the livestock but with the fueling of nuisance algae growth.
Ofcourse there's always the chance that there's some impurities in there that could build up over time and cause a crash later on... I never feel comfortable using straight tap water in aquaria.