Usually you loop the treated waste water through nature for dilution (and more filtering if you use ground water) in case there is some problem with the treatment process.

Also it is kinda hard to sell to people the concept of “you are drinking literal shit/piss” even though if you stop and think about it all lake/river/reservoir water is full of fish, bird, etc shit.