"Self-compassion is ... a prerequisite for great sex."

It might help to mitigate the impact of a partner who isn't understanding, non-judgmental and prepared to accept your vulnerability and not use it against you, but it won't make sex with such a partner "great".