In Texas, as of 2021 (last year for which I see good date), agricultural irrigation was 53% of our water usage. And something like 75% of the ag water was groundwater, much of which is from non-replenishing (or so slow as to be functionally non-replenishing) aquifers, like the Ogallala in the panhandle.
There's plenty of water: it mostly falls in the eastern third of the state. We just have to catch it. And transport it. There's also lots of water in the ocean. We just need to desalinate it. And transport it. Our problem is that we've exhausted almost all of the cheap options. We're working in the next layer of options that are more expensive, but not brutally so (re-use permits are going crazy now; aquifer storage and recovery is coming soon as well). But that will only get us partway there. Yes, conservation has to be a part of it. But even then, that has its own problems.
Specifically, the cost of securing supply and building infrastructure goes way up. So, the base cost for water for everyone has to go up. Meaning that Joe Suburb, who used to use 6,000 gallons per month and pay a water bill of $40, now uses 4,500 gallons per month....and pays a water bill of $60. He's using less water, and paying more. Because most people don't realize that you really aren't paying for "the water I use." You are paying for the means to capture and have adequate supply, and the infrastructure to deliver it. But 99% of consumers don't get that. They get the simple math: I'm using less, and paying more, and that's bullshit (it's attractive math, I give you that). Water is an increasingly scarce resource -- laws of supply and demand tell us that its price will go up. And those laws are being followed, and will continue to be followed.