It’s a good OP, in that it describes well a couple of common positions on natural selection, my 2c on both of the main issues is pretty straightforward though:
On the extent to which natural selection applies to Homo sapiens:
In my view, we’re largely outside of it. I know some quibble with this; and it’s technically true that as long as there are differences in who survives or reproduces, we’re evolving.
But humans make radical changes to our environment within a human lifetime. It makes evolution an ocean liner whose destination is changing much faster than it can even turn, let alone move.
NB: I don’t think we need to make a value judgement of us being “better” than nature to acknowledge that we’re in something of a special bracket when it comes to natural selection.
On how natural selection should influence society and our views:
Not at all, IMO.
We don’t owe evolution anything, and we do not need to “honour” natural selection or anything like that.
I’d also point out that natural selection doesn’t entail any values in itself. For example, an entity could look at nature and determine that the goal is to become extinct. And that the minority of species currently failing in this goal by having traits like enjoying sex are the unlucky ones. Who is to say that’s wrong?
It’s very natural for us to see survival and sex as success because we are among the species with those traits. From a god’s eye view, you could take either view.