I think it would depend on where you are...
Inner city NY/LA? Heck no.
Middle of no where? Quite possibly, as long as you can get it into your reservoir cleanly.
My wife and I honeymooned in Bermuda where all of the drinking water is collected from rain, quite literally the best water I have ever had to drink.
Me any my desire to put only known clean water into my tank, I would find a way to still run it through an RODI system first.