The Aral Sea might act as a warning. It was used for agricultural irrigation without concern for if the water could be replaced, and now barely even exists (https://www.researchgate.net/profile/Dan-Shaw-3/publication/...).

I live in Arizona. Most of our Colorado River water goes to agricultural irrigation. The drought is bad, but bringing in even more water from out of state wouldn't be an actual solution.