I've lived on rain catchment and combination rain/shallow well fed cisterns several times. The water was always delicious and we never noticed any physical complaints. Sitting on 200' of sand and very limited human development or agricultural spraying in area helps a lot, I'm sure.
I swear by rainwater, been drinking it out of polly tanks for decades. The government has a policy of denigrating it to the point of insisting on warnings but that's for the sheeple. They can drink their fluoride and chlorine gas, I'll stick with my pure water.