Sorry, doomsday abandonment scenario is a complete fantasy, void of any logic.
People talk about colonizing Mars, yet suggest we can't pump water from point A to B
How much is all that central valley land worth with ongoing saltwater intrusion?
Where will you get the gigawatts needed to run all the water pumps? New hydro dams?
You are throwing out a solution as if it's easy and feasible. It is certainly not easy, and feasibility , well... We shall see.
Sure, in theory there's plenty of water on the globe, and it's just a matter of getting it to population centers. In theory all we have to do to avert global warming in the first place is reduce our CO2 emissions. In practice both of those goals are essentially impossible, because it's a coordination problem and coordination problems are significantly harder than technological and economic problems.
Civilization adapts quickly once somebody pokes the bear.
There was a plan to pipe water to California from the Pacific north west, and the projected costs for that were insane.
By the time the high price of water justifies projects on this scale, there will be blood in the streets, not water in aqueducts.