What New Yorker article? You didn't link to one. I, however, linked to Yale University which has a slightly better track record on science than The New Yorker.
And, again, you are arguing that emitting less CO2 is a good thing. It is not.
And if water can be a big issue, why is AI a good thing when it uses it up? You can say "people shouldn't build data centers in those locations," but they are. And the world doesn't run on "shouldn't."
Edit: Now you linked to it. It's paywalled, which means I can't read it and I doubt you did either.