Forty-two percent of millennials say sex between people of the same gender is morally acceptable, according to a new survey.