The cost is that you deplete the aquifer. Generally speaking, water pumped out of the ground doesn’t replenish (except on geologic time scales). That’s what I meant by the fossil fuel comparison. It’s not like taking water from a stream or a lake replenished by snowmelt. Once that aquifer is dry, it’s dry, and the land becomes dead.