the goddess/creator that you talk about, champagneblossom, created all kinds of people and is responsible for sex in all its forms. i don't think procreative sex is any more sacred than pleasure sex. sex is sacred, regardless of if it creates a child, or who is involved. if anything, sex for its own sake could be considered more sacred in a pagan context, at least my pagan context!
sex is the connective tissue that binds us all. love in all its forms is sacred and should be valued and cherished. and any religion that states or implies otherwise (pagan, christian, what have you) is preaching morals (external code we must obey) over ethics (people being adults and determining what is right in context) and is controlling and not worthy of following, imho. i searched long and hard to find a tradition that values sex and love, period.
i value my body's ability to procreate. after all, i lovingly concieved a child on Beltane with a male partner. but i have had and will have female partners again. and i am very religious. kudos to cherry hill for taking a stand on prop 8.