A filter with a 100,000 gallon rating wouldn't last long...

Tapping into alternative sources may have been more about maintaining pressure in the system than about finding a water supply at 100% spec. Pressure is critical to keeping contaminants out.

(you can't build a perfectly sealed municipal water system in the real world so you rely on pressure to ensure a leak is always *outwards*)