Religion started off with sex being a good thing. A continuation of life etc. The God that won The popularity in most pantheons was the fertility gods with the creator gods being pushed aside. The mother goddesses were extremely admired too.
I think sex and issues over how it done and to who etc came later with weirdo freaks and thier abstentions with the subject.