The current disasters are amplifications and slow creeps of things we've seen before, heat wave, fire, drought.
The slow creep is the warning sign -- according to experts we should be doing a lot more than we currently are right now.
Nor should we. There is no reason to build pipelines to send fresh water to the desert.
To move that water, in either case, you have to maintain a sufficient drop in your canals/pipes to keep water flowing and prevent sediment buildup. This means that building a flat tunnel across 1000 miles, including through mountains (already an obscenely expensive proposition) is out of the question--you have to pump water up to allow it to flow downward. The energy costs--to speak of nothing else--would be incomprehensible. IIRC, damming up every possible spot in North America wouldn't suffice to provide the energy required.
More to the point, we've already put way more water in the desert than was ever there naturally, and we've irrigated perhaps 10% of it. People always want more. We've already surpassed the long-term carrying capacity of all watersheds within 500+ miles. If we pump more water in from elsewhere, we're just kicking the real problem down the road and making it worse for a future generation. There will never be enough water.
I highly recommend reading Cadillac Desert, it really clarifies this issue.
https://en.wikipedia.org/wiki/Nubian_Sandstone_Aquifer_Syste..., also.
Florida is also a large source of many crops, particularly off-season, and they are damaging the Florida aquifer through overuse which is being exacerbated by saltwater intrusion due to rising sea levels (rain falling over land creates hydrostatic pressure along the coasts): https://www.nationalgeographic.com/science/article/partner-c...
See:
https://theconversation.com/water-wells-are-at-risk-of-going...
I suspect Arizona will be screwed as they've had a housing surge without similar investment in securing new water sources.
https://calcoasttimes.com/2022/05/14/california-coastal-comm...
> that would give before any individual resident is meaningfully affected.
I think we're a lot closer to this than you seem to think.