This isn't actually true IRL unless your water table is 3 meters or lower, or you're taking about a natural spring.
Wells and pumps require maintenance, de-silting, and occasionally re-drilling. They're expensive, and depending on how low your water table is, can take a special solar setup to be entirely off grid of its electric because you have to deal with the startup impulse wattage. When a well does need work, even a deep hand-pump model, it's often expensive, up to very very expensive, and can take specialists to fix.
In places where one pump serves the community, they typically collect a small fee of equivalent to a penny a bucket. This is saved by a community-based well management committee for eventual maintenance needs, rather than one day the well stops working and you demand a month's income from every family to get water back.
You know what happens to communities that don't manage their pumps like this? One day the pump stops working and no one has money to kick in to fix it. So they don't have water anymore. So they walk miles to the next village over. Kids stop going to school just to fetch water.
And they start asking everyone else to pay for the repairs. Because after 3 or 5 years of not a care in the world and free water for everyone, fuck the system, now needing $4,000 from 30 families that live on $2 a day is ruinous.
I've seen dozens of communities like this, that had some NGO install a well, and they didn't save for the literally inevitable need for repairs. And they whined and cried and said "we'll do better this time!" as their kids pulled fetid water from a stream 1km away. And not rarely, I have seen communities that had 2 or 3 wells, one after another, and never ever saved for fixes. I've has some lie to me "no, we never had a well!" as hydrology records show where the pump is, and you can still find the well head right in the middle of the village. And they all wanted to rely on others to start the cycle over again, rather than do the miniscule work up front.
So maybe get out of your privileged, idealized, naive mindset and think things through. It's cute so be make the subscription model joke, but to defend it like things IRL work by magic is insulting to kids something from the same attitude in their parents right now.