UGH. Sounds atrocious. I feel lucky to have great tasting water from the well.
We keep about 30 gallons of water in gallon jugs as emergency prep. Hardly ever have had to use it. Even though the well pump doesn’t work when the electricity goes out, the first thing I do is drain the lines into clean quart or gallon containers. That’s usually enough.
Hubby says he could hook the generator up to run the pump in no time at all. I told him, I’d rather do it now and then I could just flip a switch. He sees no point to expending that effort on his part.
He is in favor of the automatic stand by generator though. That’s because when we do have to use the portable generator and run power cords to the stuff, he has to expend effort. You see how it is? LOL
We have some water purification tablets, and some filtration bottles, and replacement filters, and directions for making your own filtration system if stuck in the woods.
Figure if we had to, the swimming pool water from the rain, or the creek water could be used in mega emergency situation.
You sound well supplied (HAH! I slay me!) for emergencies.
We keep several gallon jugs as backups, too.
Your very fortunate on your water. Probably over 30 years ago I had trouble with my washing machine and a man from Sears came and fixed the problem then saw my fabric softener container and how caked it was with the blue substance. He told me I was damaging my washer and wasting money on the blue softener. I was told to only use clear vinegar. I have been using vinegar for many years and even have my friend in England using it as softener.
For you older friends here if you remember your moms put vinegar water on your hair after she washed your hair years ago if she didn’t have rain water.