I think that perspective is much more true to the Scriptures than the concept, "God is pro-sex!!!!!! Giggety!!!!!"
We can say, "Sex is good," in the sense that when God, at the completion of creation, "saw that it was very good," creation included human beings who would reproduce through sexual relations.
Unity and intimacy between spouses is good, and sexual relations can be a way in which unity and intimacy develop and are expressed. (Or not.) And of course, procreation is good - "Be fruitful and multiply" was the first commandment - and sex is the only way in which that happens.
The Bible says marriage is one man one woman; and says the marriage bed is holy.
“Marriage is honorable among all, and the bed undefiled; but fornicators and adulterers God will judge.”
Hebrews 13:4
Assuming we believe that Jesus is God, and God wrote the Bible, then I think it is safe to assert that Jesus says sex, within the context of biblical marriage, is good.