The recent tragedy in Texas is a key example -- way more water than could be "handled", and if there were mitigations in place it could have been win/win (temper flooding and replenish aquifers.
I follow a youtuber who's trying to rehabilitate desert land by slowing the water down to let some percolate in -- it's a wonderful dream: https://www.youtube.com/@dustupstexas
I'm not sure I understand where you see a contradiction. Land areas are using groundwater faster than it can be replenished, so land is getting drier. That's according to the article (just basing of the summary not the scientific one) is driven by both overuse and drier and warmer weather. The thing is, that's a feedback loop, if it gets drier we'll be using more groundwater for irrigation. So both processes are driven by climate change.
It wasn't that there is a contradiction. If the over use has been happening for decades, and it's at a rate faster than historical replenishment could happen anyways (before "climate change), then this would indicate that over use is the primary cause. Drier weather is a contributing factor in the pace of depletion, but in no way could be the solitary cause nor cure. Even in the article they mention the demands related to a growing population and industrial agriculture (article also mentions potential food scarcity).