Any insights on when does "moderate" use of alcohol become alcohol abuse?

Yes. Alcohol becomes abuse when it starts affecting your life negatively:if you having problems at work or showing up late or missing work; if it is making you fight with others or causing problems in your relationship; if you have legal problems from drinking; if you find yourself "sneaking" alcohol or hiding how much you use from other people.