Americans' views on alcohol are changing, with many now saying they don't drink because it's unhealthy -- especially Gen Z.