I find it amusing that people discuss the Vatican as if it has any real power or influence anymore. Even in predominantly Catholic nations, few people heed its tenets completely. Considering the number of apologies it has had to make in the last few years (acknowledging evolution to be legitimate, acknowledging Galileo as correct, admitting its vices in the treatment of Jews during the Middle Ages etc), and that the apology that it will surely make about the molestations of young boys, I can't see its prestige improving any time soon.
I actually find it curious that the Pope even chooses to render judgements on certain topics, such as contraception. He could've simply not rendered an opinion, but instead chose to alienate millions of Catholics.
One way or the other, future Pope's are going to have to accept certain changes in society, because not only do they have no choice, but they risk becoming obsolete by denying it.