Even as population has almost doubled, and as agricultural output increases, we have decreased our water usage:
https://www.ppic.org/publication/water-use-in-california/
There's a lot to be said for simply not wasting lots of water.
If California stopped growing alfalfa, a low value product that is the largest agricultural use of water, we could probably house 20-30M more people with that water.
California could have built more reservoirs, but how many more? And how many more natural beauties would we have sacrificed instead of simply using less of a resource?
The stupidest thing California does is treat water rights as economic land for farmers that simply waste obscene amounts of a valuable resource. We need to tax that economic land at the full land rents, to encourage more economically efficient uses.