Football fans, especially drunk ones have become violent and dangerous at emotionally charged matches. In some cases, with deadly consequences, so restricting public alcohol consumption isn't necessarily a bad thing. Especially when the host country has lots of limits on the sale and consumption of alcohol. Are you going there to drink or to see the matches?
It is, however, illegal to be intoxicated outdoors, which is where the World Cup ban comes in. Qatari officials have also expressed concerns over the relationship between alcohol and soccer-related violence, as seen in the clashes between English and Russian fans in France during Euro 2016. There will be no alcohol consumption on the streets, squares and public places .
There are a lot of people that think public consumption of alcohol should be banned. Public consumption of alcohol leads to public intoxication. And drunks in public can do a lot of dumb things and cause a lot of problems. It is not that far out of the mainstream to not want alcohol consumption in public.
In the world of big sports tournaments, the host country is always able to set rules and regulations for the tournament. Qatar is completely in the right to decide to ban alcohol during the World Cup, and the rest of the world would literally have to fight them to change it. Maybe that should be a consideration for the World Cup venues in the future.