Trust me, Pope doesn't advocate my position. If he did, he'd be kicked out from Vatican before you could say "condom".
On a serious note, it seems to me that Catholic Church advocates two things: no extra-marital sex and no contraceptives, which means only sex within wedlock is sin-free and only for the purpose of procreation (since contraceptives are a no-no). Although, quite naturally, there are instances where married couples engage in sex for the specific purpose of getting children, most of the times it's just about sex.
So, although Catholic doctrine isn't specifically anti-sex, it is so confining that it would allow you to have sex only under very specific circumstances which happen rarely. I'm not Catholic (and even if I were, I'd probably ignore the Pope, just like I ignore the Patriarch) so it's all the same to me, just saying how I see it...
Bookmarks