Ponds here are lower than I’ve ever seen; many are dry. Creeks have only a few stagnant holes left. Wells in the creek basin would be the only back-up if rural water shut off.
I have some pump jacks, leathers and such I stashed back in Y2K days.
Primitive wins a lot of country battles.
Primitive works, if it filters well. Boiling also works, after the big chunks are out.
You are correct that country boys can survive.