Could be made socially unacceptable like smoking.
Maybe expand the mind a bit, visit a strict Arab country or something. They don't drink much there. Has nothing to do with health though. It might help get a picture what kind of society they are advocating for.
I'm all for dropping restrictions on things that people can do that don't harm anyone else, but frankly I don't care to spend more money on health insurance because a bunch of people want to drink too much.
It's unlikely that something as ingrained as alcohol will be made unfashionable except on multi-generational time scales.
That being said, the current trend of alcohol in every aspect of life might become pase, as more individuals seek to avoid drunkeness/temptation outside of a bar.