There's a whole think tank report on this technology trend and the consequences. I don't know if they are a little optimistic on the timelines, but the science and economics is sound.

I used ChatGPT to combine data from this report and the USDA Ag census to do a back of the envelop calculation on how much water will be saved in a certain region and what would happen if most of that water made it back to the dying lake it was diverted from.