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.
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.
Very trivial to extend the idea to routing water from any of the thousands of lakes in Canada.
Vegas had a plan to do just that (though from Reno). These ideas aren't pursued because water is not scarce enough for them to be economically justified yet. If the time comes, they will do it and likely cheaper than you think.
If renewables eventually take over, we can even repurpose the existing oil pipelines. Likely need to widen them, but much cheaper than land use/zoning legal battles.