Could this be interpreted to mean The LORD [YHWH, Yahweh (H3068), God the Father) is telling King David's Lord [Adon (H113), Adonay (H136), God the Son] to wait until He (Yahweh) kills the wicked of the earth and has their bodies taken to "winepress of the wrath of God" (Rev 14:19). And that these bodies will be the Son of Man's (Adonay) footstool when "He will sit on the throne of His glory" (Mt 25:31) to judge the surviving Armageddon sheep/goats?
No, I don't think that's the case. Rather, the reference to "footstool" in Psalm 110:1 is, I believe, a reference to the temple.
See the following:
1 Chronicles 28:2 ESV,
Then King David rose to his feet and said: “Hear me, my brothers and my people. I had it in my heart to build a house of rest for the ark of the covenant of the Lord and for the footstool of our God, and I made preparations for building.
Psalm 99:5 ESV,
Exalt the Lord our God; worship at his footstool! Holy is he!
Psalm 132:7 ESV,
“Let us go to his dwelling place; let us worship at his footstool!”
Isaiah 66:1 ESV,
Thus says the Lord: “Heaven is my throne, and the earth is my footstool; what is the house that you would build for me, and what is the place of my rest?
Lamentations 2:1 ESV,
How the Lord in his anger has set the daughter of Zion under a cloud! He has cast down from heaven to earth the splendor of Israel;
he has not remembered his footstool in the day of his anger.
In each of the five instances listed above, there is ample proof that "footstool" is a metaphor for the temple, that is, the House of YHWH.
The question then assumes, from Psalm 110:1 that since the enemies are to be turned into a footstool, it conjures the image of a conqueror with his foot on the neck of the subdued.
But consider, in light of the Messianic nature of the prophecy, and how it was interpreted to apply to Jesus of Nazareth, that within a Christian context, Jesus came to save (i.e. not conquer) His enemies.
For example, Jesus taught His students to "love [their] enemies".
Paul, quoting from Proverbs 25:20, writes that if an enemy hungers, the Christian disciple should feed him/her. If the enemy thirsts, the Christian disciple should give that enemy something to drink (Romans 12:20).
Earlier in Romans, Paul writes of how Christ died for His enemies, in order to save them from the wrath of God:
Romans 5:6-11 ESv,
6 For while we were still weak, at the right time Christ died for the ungodly. 7 For one will scarcely die for a righteous person—though perhaps for a good person one would dare even to die— 8 but God shows his love for us in that while we were still sinners, Christ died for us. 9 Since, therefore, we have now been justified by his blood, much more shall we be saved by him from the wrath of God. 10 For if while we were enemies we were reconciled to God by the death of his Son, much more, now that we are reconciled, shall we be saved by his life. 11 More than that, we also rejoice in God through our Lord Jesus Christ, through whom we have now received reconciliation.
Jesus didn't come to destroy, but to save (John 3:16-17).
Indeed, the whole mission and purpose of the Messiah, from both an Old Covenant, prophetic context, and a New Covenant, fulfillment context, the overwhelming evidence is that Jesus was sent by His Father YHWH to redeem and save, reconcile, forgive, purge of sin, justify, and sanctify people who had been alienated from God, and in their alienation, had become His enemies.
This then lends to the idea that YHWH sent David's Lord, that is, the Messiah, Jesus, to peacefully and lovingly subdue, as it were, His enemies, by taking their place and paying the ultimate price for them, a substitutionary death on a cross under the judgment and wrath of God.
So, when I read Psalm 110:1, and I see the reference to the Messiah's footstool, I think of what God and His Son accomplished to save sinners and turn them into recipients of the Holy Spirit, whereby they are made a temple, that is, a footstool unto YHWH and King David's Lord (See, e.g. 1 Corinthians 3:16, 1 Corinthians 6:19, 2 Corinthians 6:16, and Ephesians 2:21).