Sorry, but that is a cute way to say "take water from people who have it".
For decades, southwest states have put up billboards in rust belt states to entice workers to move in order to keep workers filling their economies. Much to do was always made about the great climate. So if climate is an economic advantage, so is easy access to water.
These large bodies of water are not just for irrigation, they are the method for which much of the nation's harvest of grain is moved to eastern ports. It still is used to move the raw materials for steel production. Tapping the Great Lakes to support California's insatiable thirst will only drop the lakes to a level where shipping becomes unprofitable.
Climate change is already making food growing possible in some formerly unlikely locations. I'm exactly at latitude 42 degrees (it runs right through my living room). Not a mile from my home, they grow broccoli and other vegetables right up until December 1, unheard of twenty years ago. They are now on the second planting of lettuce a week into May.
Climate change is going to take that market away from these states whether they have water or not.