that study doesnt compare coffee drinkers and alcohol drinkers, it compares moderate alcohol drinkers to non-drinkers and heavy drinkers. i also rly have to question the methodology, all they did was get a bunch of old ppls names and drinking status then wait for them to die so they could look at their death certificates. the ppl who were heavy drinkers at the age of 55 could easily have stopped at the age of 56, someone who was a heavy drinker at age 54 could easily have abstained at age 55 and been listed as an abstainer, etc. this study is shit, and theres also this pretty enormous qualifier tucked in:

A model controlling for former problem drinking status, existing health problems, and key sociodemographic and social-behavioral factors, as well as for age and gender, substantially reduced the mortality effect for abstainers compared to moderate drinkers