It's a tragedy of the commons because groundwater is legally a common resource that anyone can exploit as they see fit. You can't charge market prices for it without changing that picture and declaring that someone else (eg the state) has a property interest in the groundwater, at which point it's no longer in the commons.