Well I know that I have been a non drinker until the age of 27 and I still often don't feel the need to drink alcohol even in a social event especially if I have to drive (better to say I don't drink tonight than starting and count your consumption). I could and still definitely observe it on long family dinners. But it depends a lot on the people tolerance and the kind of drinks. There are worlds of difference between a 4% of alcohol beer and a 6.5% one if you have a pint.
My mother has always been laughing stupidly with a single glass of wine, my father could drink 3 before you notice. Same when I am not drinking and my partner have a beer. She won't speak louder or do act differently after 1 or 2 light beers. But in her case the line is really thin between the virtually unnoticeable state, the moment you realize she should stop drinking and the moment she is completely wasted or start feeling bad, especially if the drinks are stronger. On other people it is more gradual.
Does this no answer your question about my child see me drinking beer? Or drinking coffee, if it's easier to not get distracted by the specific drink he's not allowed?
My point was a bit unrelated to all this, so I'm just checking your original question's answered.
It looks like you have unresolved issues (trauma?) from being around alcoholics or people with lack of self control. But I don't. One beer with a meal is not "disgusting" and does not significantly impair an adult either.
It just disgusts me personally. There's probably a lot of factors involved. But there's no such thing as a safe dose of alcohol. Especially ingested routinely.