According to available data, there are approximately 345 stadiums worldwide with an average of 40,000 seats. There are, on average, 3 or 4 per country in major cities of ~700,000 people. These stadiums play, on average, 25 games per year with an average of 64% attendance at ~30€ per ticket.
I agree that football causes a "carbon footprint" as a consequence, especially from so many people moving.
However, from the data, roughly estimating, 30,000 tickets x 30€ x 345 stadiums x 25 games per year = 7.76 billion €/year. I'd argue that the taxes and fees from this revenue alone compensate for the water and energy costs of these stadiums.
In regard to the overall "carbon footprint" of football, it can also be said that the sport generates many other significant revenue streams directly or indirectly, such as advertising, video games, clothing, food & beverage industries, etc., which all are taxed and further alleviate its "carbon footprint".
Besides these, there are also intangible values such as the benefits to culture and people that can't be understated and are difficult to quantify.
Lastly, even if grating that "CO₂ emissions" and "carbon footprint" is an established science, and that football causes harms in these terms. It's not clear how it would be any different from anything else that moves billions of people. Which begs the question: are museums not great because they cause people to travel? How is football more inherently polluting than tourism? If so, then doesn't this line of reasoning lead to anti-humanism?
In conclusion, considering the fact that anything we do has a cost, that it wasn't demonstrated football is inherently more polluting in comparison, that measures exist to counteract the inevitable "carbon footprint", and that it brings many great benefits, as well as the arguments I've made in my opening statement, football is the greatest sport in the world.