Can't say I approve of anti-alchohol songs per se, but there are some great temperance songs around. Then, of course, there's that great rarity, the anti-temperance song e.g. Poison Beer:
"Well, fancy then calling it poison,
Nasty names like poison beer.
With them I can't agree,
For I've drunk gallons and gallons of beer
And it never did poison me,
No! It never did poison me.
For I've drunk gallons and gallons of beer
And it never did poison me."
Happy drinking
Tom