Well that’s obviously bollocks isn’t it. If self sustained damage signals status and fertility, why would we do it in a way that impairs judgement. People would be carving patterns onto their faces, inserting stones under the skin, engaging in elaborate rituals involve pain etc.
Oh, wait....
And you need your wits about you to undertake such practice.
Impaired judgment doesn't indicate high status, quite the reverse. I can’t imagine our ancestors had enormously respect for the staggering drunk any more thank we do.
Altered states about access to alternative realities, the spirit realm etc. Traditionally even tobacco is about entering an altered state for spiritual reasons.
Alcohol was probably always about celebration, feasting etc