I wonder if this is helpful? 'You are screwed no matter what you do' is not a good way to motivate people to action. People have heard this all before, and don't trust it. You can only cry wolf so many times with apocolyptic stories.
In the UK after a prolonged drought in Southern England the news announced something like, 'The aquifer is so depleted that it will take years to recover'. Then came 3 months of the wettest summer on record. I remember a local fishing tackle shop going out of business because noone could fish due to flooding! The acqifer filled in 3 months.
Then I saw a village in Southern Spain where the acquifer dried up. Someone realised that the Moors had built an ancient water harvesting system in the hills, at least hundreds of years before, and because of rural depopulation the knowledge and labour to maintain them had been lost. The abundance of water was not natural, it was human created, and then human lost.
I think the final problem I wanted to speak about is the 'it's the end users fault' problem. I pay for my water, through water rates (a tax on the property I live in). Others have water meters. The company that gets that money has to supply me water, and take away my sewage. The company used to be a public utility, but was privatised when I was young. When there is a drought they tell me I should shower rather than bath, they ban the use of hosepipes! They tell me to buy low flush toilets and more efficient washing machines. But they never share that pain, they still make massive profits for their shareholders. The private water companies in the UK have not built a single reservoir since privatisation in 1989. To be fair most of the water infrastructure is Victorian. The infrastructure that filed reservoirs was left unmaintained. A staggering amount of water leaks from pipes in the road. Their solution is for me to use less water, so they can continue to get rich. And they know that they can fail to invest forever, and the government will have to bail them out. I suspect this is the problem in other places too.