A direct comparison of drinking water from the tap with unrefrigerated bottled water shows an environmental impact of tap water which is less than one percent of that of bottled water.
It's pretty obvious, just by looking at a bottle of water, that it's not very good for the environment. Now we know how much worse. And personally, I can't tell the difference in taste. And I've never gotten sick from tap water.