Sure, I don't want to drink rainwater that fell on my asphalt shingle roof. I also don't really want to drink the rain water the ultimately ends up in the river I live near to and which the city sewers empty into (including upstream cities) but that's what they do. Sure that water is treated before it arrives through pipes into people's houses.
I'd take properly collected and treated rainwater directly from my own property any day over that.
Rainwater isn't pure water. It will contain dust and pollen. The system it lands on (ie a roof) will also have other things land on it (birds/insects etc). So by the time it gets to the storage tank the "pure" rainwater might contain a wide variety other stuff. Drinking it without treatment isn't always a great idea.
This is not the kind of system you'd probably find doable on a small city lot and yes I guess people would be tempted to just drink their asphalt shingle roof runoff - until they see the water. But the context presumably is acreage type off-grid living. The landscape can also help. Dunno if you saw a recent-ish article here on HN on some South American farmers directing rain water such that it flows slowly through various layers on slopes until it reaches the bottom even having it re-emerge as natural springs in some places. Won't work if you live on the prairies, sure. Could work in other locations.
That said, you must separate humanure from safer waste which may be applied as crop dressing in as little as 18 days using hot composting methods.
For more details checkout my YouTube channel:
https://youtube.com/c/RussellBallestrini
An easy compost toilet is a bucket to poo into and woodchips or sawdust which is high carbon and soaks up smells and liquids, is layered after each use, emptied into a dedicated pile oftened tarped to control moisture.
I believe it is possible you just have to be really careful with how it's treated, especially around vegetables etc.
There's also a natural blackwater treatment system, briefly mentioned in this really great video from one of my favourite Permaculture teachers (EDIT: it's at 46:45), which also happens to be a great introduction to Permaculture if you're interested: https://vimeo.com/95060300
Does that make it safe or make it worse?