Also advertising drugs of all kinds should be illegal. Sports will have to find some other way to finance themselves.
I'm genuinely curious about what goes through people's minds when they propose these obviously flawed measures
What I see when someone proposed stuff like this is someone saying "my views on how you should behave should be forced on others through violence", a view that is flawed because by its very existence it fundamentally justifies the very opposite policy.
If you can force your views on others purely because you are in power, then others are also legitimate in forcing their views on you when they are in power... But somehow I suspect that when you look at how a country like Saudi Arabian treats your preferred group like women or LGBT, your first reaction is not to say "they are right in treating them this way".
Banning harmful substances, or their use in public (to lower the amount of people exposed to them, and to lower the chance of younger people taking them up isn't "cultural norms". It actually genuinely works, and has public health benefits.