You also have to consider the volumes of water needed by drought stricken areas like the US southwest.

California uses 1.8 million barrels of oil per day.

California uses about 91 gallons of water per day per person. That translate into 84.5 million barrels a day.

​

The construction costs, and engineering required to moved THAT volume of water across the country make it completely unfeasible.