Many Americans are unaware of the connection between drinking and cancer risk, despite growing research that points to the negative health impacts of alcohol.