Also, agriculture isn't necessarily sustainable just because it doesn't require artificial irrigation. As an extreme example, just look at the Amazon. The land used to grow a water-intensive species might be better used for other purposes.
And for the rest... talking to climate doomers isn't interesting or productive. You'll only believe negative things, you demonstrably here don't know what you're talking about and just make things up to fit the narrative you have in your head. You clearly knew nothing about cotton production but made up facts without bothering to look for information at all. You make up your climate facts as well, do you know anything about the climate models for what will happen in the cotton growing regions of the US? Or have you heard vague things about droughts and decided to parrot those and assume they apply here because they supported your doom thoughts?
The problem with farming resource calculations and fearmongering, is often they measure water usage of a particular crop without really considering where the water came from.
Wouldn't you say crops grown with just water from the rain were using water with perfect sustainability?