The issue is mostly due to the fact that those who don’t drink because of existing damage to liver etc from alcohol or those who cannot drink for other medical reasons are included in the data. If you control for existing health issues then the results show that drinking more alcohol decreases life expectancy.
Beans on toast.