There’d have to be a serious energy revolution that collapses the cost of electrical production- before big long distance high volume water transport scenarios like the one you suggest become reasonably cost effective.
I think that’s going to happen. There’s currently a very large race underway among a half dozen companies world wide —including one canadian company to produce the first lftr thorium reactor. The big promise of these reactors is that they will cut the cost of electrical production to 1/4-1/10 current lowest cost coal. These reactors are portable. They can be put on the back of a semi.
The problem here is that these reactors will bring closer the holy grail of the water industry. Desalinized water cheap enough for agriculture. Energy is up to 1/2 the cost of desalination. So if you chop down the price of energy you also chop down the price of desalination. Plus cheap energy would make it cheap to pump water inland.