I assumed you would be very turned off by the "Carnal Exaltation" tenet though.
I don't understand CK well enough to know what that means exactly, but you're right that the term itself does not inspire confidence.
For all the major Christian and Muslim faiths in the game (and Jewish too come to think of it), the "Lustful" trait is considered a sin that hurts the character's Piety score, while the "Chaste" trait provides a boost. This inverts that, being chaste is a sin, being lustful is a virtue and gives a boost for piety.
...it ain't a perfect description of the sort of contemporary thing I was shooting for obviously but it's the closest thing the game has to sex-positive, hence why I used it.
(Also because it's beneficial from a game mechanics perspective, as you can see it increases fertility of all adherents of the religion, as does the "Lustful" trait, while "Chaste" limits fertility. So it results in characters having more kids and larger families, which provides a boost to the Dynastic Renown score.)