Peter Leithart has been discussing the Song of Songs and has touched on a number of relevant issues. This post is good on the transcendence of sex. Here is an extract.
"What assumptions about sex are behind the common opinion that the Song (of Songs) is only an erotic poem, only a celebration of human sexuality and marriage, full stop? (Tremper Longman: “There is absolutely nothing in the Song of Songs itself that hints of a meaning different from the sexual meaning.”) When commentators express such opinions, are they already implicitly assuming a materialist view of sexuality? Are they coming to the text with a presupposition that sex has no inherent transcendent meaning? To put it the other way round: Doesn’t sex itself hint at a meaning different from the sexual meaning?"We are complex, multi-layered beings, and the whole-hearted embrace of our physicality is a joyous and fearsome thing, for carried out faithfully it leads to encounter with the resurrected Christ. And that takes us way beyond ordinary religion's use of the resurrection to merely talk about an individual's personal existence after death.