https://en.wikipedia.org/wiki/Droughts_in_California
> Drought is intrinsic to the natural climate of California.[6] Across the Californian region, paleoclimate records dating back more than 1,000 years show more significant dry periods compared to the latest century. Ancient data reveals two mega-droughts that endured for well over a century, one lasting 220 years and one for 140 years. The 20th century was fraught with numerous droughts, yet this era could be considered relatively "wet" compared against an expansive 3,500 year history. In recent times, droughts lasting five to 10 years have raised concern, but are not anomalous. Rather, decade long droughts are an ordinary feature of the state's innate climate. Based on scientific evidence, dry spells as severe as the mega-droughts detected from the distant past are likely to recur, even in absence of anthropogenic climate change.
The land dried up and the grasses headed out miserably a few inches high and great bare scabby places appeared in the valley. The live oaks got a crusty look and the sagebrush was gray. The land cracked and the springs dried up and the cattle listlessly nibbled dry twigs. Then the farmers and the ranchers would be filled with disgust for the Salinas Valley. The cows would grow thin and sometimes starve to death. People would have to haul water in barrels to their farms just for drinking. Some families would sell out for nearly nothing and move away.
And it never failed that during the dry years the people forgot about the rich years, and during the wet years they lost all memory of the dry years. It was always that way."
John Steinbeck, in 1952
You're right that it's going to be massively disruptive to how we currently live our lives. A good chunk of us are going to need to find new jobs. IMHO the trigger will be when money becomes worthless, when we see the first billionaire die from a climate-related natural disaster and money can't save them. But I'd question our inability to save ourselves. In the Great Depression we built huge swaths of infrastructure in very short time periods - the Hoover Dam was constructed in just 5 years, the Golden Gate Bridge in 4. That was with 90-year-old technology; when we pull out the stops, we can do even better today. The Oroville Dam spillway was reconstructed over 6 months [1], while Foster City just built a new levee around the entire city in 3 years [2].
[1] https://en.wikipedia.org/wiki/Oroville_Dam#Investigation_and...
[2] https://www.sfchronicle.com/bayarea/article/foster-city-sea-...
Virtually all infrastructure has been built for local environmental conditions that, on average and with the exception of highly localized catastrophes, has been relatively unchanged through human experience. Now that is changing for everyone everywhere all at once. It's very easy to say "just build aquifers for 4-6 year droughts!" But this also has to be done with the just-as-easy-to-declare "just build storm surge walls", "just build the grid to be resilient to ice storms", "just grow different crops" etc.
This is going to take a lot of time and a lot of money and a lot of resources (resources we probably don't have). We're also not really sure what the new normal will settle on, so new infrastructure could still prove inappropriate 2 decades down the line.