I see now that Time reported on a pretty large scale international poll of Catholic attitudes to various sensitive issues earlier this month. The results are pretty interesting, and on issue after issue, the really outstanding conservative Catholic attitudes are shown in the results from Africa and the Philippines.
On gay marriage (a more specific issue than mere acceptance of gay relationships) look at the results:
Well, there's not going to be any movement on that issue if the Africans have their way!
(And I see that while the Pew poll indicated the Philippines accepted gay relationships, they apparently don't go as far as accepting gay marriage.)
But look at the other issues on which the Pope is trying to hold a firm line. On contraception, the results are pretty clear that the Church has lost everyone (except, oddly, a lot of Filipinos):
I think the figures for those opposed to contraception in the US are also unusually high, but perhaps the political argument over the contraception mandate in Obama's health plan has heightened feelings against it.
But even on abortion, clearly, Catholics pretty much do not follow the straight-down-the-line teaching by a pretty big margin:
Mind you, that question is a pretty broad brush one and allows for some confusion.
In any event, the main point I take from this is that Catholicism has the same issues as the Anglican Church: it is pretty fractured on some key teachings on matters of sexuality.
Update: William Saletan talks about the same polling, and notes that it reveals big age differences on matters such as gay marriage, indicating that the Church's position on sexuality generally is going to face continuing strains.
