I had a well dug, 24 years ago. It cost me $500, and has since given me good, clean water, and 23 years of various veggies, out of my garden.
The small electric pump uses pennies per day, and I have a hand pump for power outages.
All the folks around me have wells....I think I’m the only one with a manual pump, though.
Not that big of a secret.
However, I doubt that would work for the average city/suburb dweller.
And truthfully a lot of rural folks are out in the cold as well. Myself included. Sometimes the water table is too deep and the water to alkaline to drink.
I live on a lake and could haul water if push came to shove...but until that happens I think I'll just pony up the dollars to have a faucet turn on and water come out.