“What they all have in common, is that they are turned away from what Biblical revelation holds to be good: natural procreative sex. That is, in Biblical terms, an exceptionless norm. See for yourself.”
And there is where you are in error.
Biblical revelation endorses only sex between married couples.
He endorses this sex for pleasure, “Drink deeply, O lovers.”
This leaves all other sex as morally wrong.
But I agree with all that. Did you think I disagreed?
Then how is that "where" I am in error?