Behind the push to make smoking and vaping illegal for a generation of Canadians
(vancouver.citynews.ca)
The Canadian temperance movement was largely a success, that went on for a long period of time in a number of regions.
It didn't so much fail (as it did in the U.S) as It was abandoned due to government disinterest due to lost tax revenue, societal transformation due to urban centralization and the generational shift that coincided with the allure of the short lived age of the roaring 20's.
In the U.S, it can be argued that it was profiteers that dismantled prohibition. Not society. They've pushed the message that "prohibition can't work" ever since.
https://thecanadianencyclopedia.ca/en/article/temperance-movement