Misleadingly provocative headline, right? The actual ruling from the article is that the US Constitution does not by itself grant US citizens that right. As the article itself points out, there’s nothing stopping other agreements from granting the right, and indeed several states do so explicitly.
I think the bigger deal is that the people of Jackson were lied to and this sets the precedent that there is no recourse. It's not like someone in Flint knowingly drank contaminated water, the city withheld the fact that their water was contaminated with unsafe levels of lead.