Alcohol increases the risk of cancer, but some Americans think it does the opposite, a new study shows.