Millions of people across the country drink recycled sewage every day. That's the nature of water--it just gets recycled.
Maybe I just find this odd because I was always under the impression that every city did it this way. When I was little, one of my uncles worked at the waste water treatment plant in a small city on a small river in the middle of the country. I thought it was common knowledge that the water flowing in the water treatment plant (for city taps) came from the river, and the water flowing from the waste water treatment plant flowed back into the river. So we were drinking the treated waste water from towns and cities upriver, and the towns and cities downriver were drinking ours. So we had a valid interest in the proper operation of treatment plants upriver, and those downriver had a valid interest in ours.
My uncle used to tell me how he would sometimes have to give tours, which were billed as sort of educational exchanges, for people from other treatment plants in the state who wanted to visit. But they were always only from the treatment plants down-river--it was sort of spy/audit trip. And that was considered okay, our city did the same thing. Keep in mind this is a pretty small river, not an extreme amount of dilution going on here.
Are there any cities that truly have a landfill of sorts for treated sewage water? A place where it can go that it will not end up back in the drinking water? Because I think that is what would be extremely rare.
I think CA politicians are marketing this all wrong and causing resistance where there shouldn't be any. This is just how it's done. Water gets recycled. There is no absolutely pure water source unless you create it in a lab. How the water you intend to drink is treated is the key.