There are lots of places where data centers could be built. If 100 towns reject data center construction and one allows it, the data center gets built. Doesn't even have to be in the US.
A lot of the push back excuses against data centers has now been unmasked as total lies - like the water story - and other negatives can maybe be addressed - and the benefits are downplayed because F billionaires and F ai, right? But as rightfully pointed out, datacenters have many places they could go, and as emotionally made decisions deprive communities of the benefits, people in other places will wake up and say "uhm we want the benefits THAT place over there got from a datacenter" .... Of course the more people push back for emotional reasons the higher the probability that many communities will have permanently missed the boat, because their pushback forced it to go overseas (much cheaper!) or even space.
Practically the issue is not towns allowing it but the electricity connections, which are being blocked by state legislators.
Even Texas has paused electricity hookups which has stalled several builds and expansions.