I mean to an alcoholic in the small scale it sounds like it's working out great.

But Canada's recently done a study that shows the taxation gained from alcohol consumption is far less than the deleterious societal costs.

Effectively the government loses money on every bottle it taxes.

edit: This is known as Canada's alcohol deficit. It was first studied in 2014 which showed a taxation intake of ~11 Billion while the social costs were estimated to be ~15B resulting in a deficit of about ~4B. believe the 2020 study showed the alcohol deficit is up to ~6B a year now. I'm lazy, but here's one link for those who'd like to know more:

https://www.canada.ca/en/public-health/services/reports-publications/health-promotion-chronic-disease-prevention-canada-research-policy-practice/vol-40-no-5-6-2020/alcohol-deficit-canadian-government-revenue-societal-costs.html