https://hellawater.com/why-is-my-water-brown-causes-solution...
Here's one link amongst many a quick Google search that explains how low system pressure from increased demand can cause discolored water. (Check out the section on municipal water supply disruptions) I live in new orleans and entire neighborhoods need to boil water in periods of high demand.