Depends how you do it. My mom’s backyard is going from useless lawn to cares-for fruit/veg garden.

Water consumption is going up. Dunno if our practices use less than buying what we produce.

To be fair the comparison isn't between growing your own and buying in a grocery store. If you get anything useful out of it then I think that's arguably a better use of water than a lawn.