For decades, studies suggested that moderate alcohol intake could protect the heart, reduce diabetes risk, or even help you live longer. Newer research tells a different story.