I don't have a problem with moving water to support agriculture in those State. That's something that was fairly well solved in the San Joaquin Valley long ago.
But that is not what this opinion piece purposes. They summed that up with "Los Angeles couldn’t exist without the California Aqueduct. Phoenix and other cities in the Southwest are in the same boat. Their future survival depends upon finding large amounts of new water."
That is an entirely different issue. In all of Arizona there are approximately 138,000 people that work in agriculture. That's not even in the top 10 industries in Phoenix. About 40% of the water used in Phoenix is used for farming. Phoenix-area residents use over 50% of the water they get from city water supplies for watering lawns and maintaining swimming pools. [1]
When you look at the growth of metro areas there it seems pretty clear to me that growth is not sustainable.
1: https://askabiologist.asu.edu/questions/how-much-water-are-w...