Above my pay grade, mostly, but we do keep flirting with these severe drought situations. And, basically, they're such that the water keeps flowing until it doesn't. And when it doesn't...
Nothing is certain and predictions about the future are hard, and, again, above my pay grade, but "major US city with crippling drought" seems like a pretty likely event sometime in the near to medium future!