When it comes to drinking for health, 'what we believed for decades might not be true,' new research suggests