>Certainly Song of Songs (in the OT) presents erotic intimacy in a positive manner, and does not to my recollection mention procreation.

Shir haShirim is a Jewish text. Christians sort of awkwardly avoid bringing it up, because, well, yeah, it's ancient Hebrew erotic poetry.