The Church is not shooting itself in the foot on this one. People say the same thing you did about: gay marriage, women priests, abortion, homosexuality and a bunch of other things that are morally unacceptable.
Women priests are “morally unacceptable”? Hilarious...