I’m not supporting it, but how is it inconsistent?
I can speak more to the Catholic view than the evangelical, but if you accept the initial premise that there is a creator God then the rest follows fairly naturally (you can look the ‘the theology of the body’ if you want to read more)
If God wanted people to only have sex for reproduction why didn't he design the body so that sex was only for reproduction?