The woman riding the beast is not destroyed at the second coming - but before then, by the ten kings, in Revelation 17:17.
You have some of the entities mixed up.
The woman is the Vatican. To be burnt to the ground by the ten EU leaders.
Mystery Babylon, mother of harlots and abomination of the earth, is the spiritual kingdom of Satan and his angels.
You are hijacking the thread, but I could not resist.
Bringing it back on topic:
"And the woman which thou sawest is that great city, which reigneth over the kings of the earth."
"So he carried me away in the spirit into the wilderness: and I saw a woman sit upon a scarlet coloured beast, full of names of blasphemy, having seven heads and ten horns."
The woman and wilderness is an ongoing theme in Revelation, no?
This city was not historically the city that reigned over all the earthly kings. This was describing Jerusalem at the point of the 7th Trumpet. The Vatican did not reign over Babylon, the Medes and Persians, Greece, nor Rome. The Vatican is a young nation compared to Jerusalem and Israel. The Vatican may have been the little horn that replaced 3 horns, but is certainly not the woman riding this 7 headed beast in Revelation 17.
The dragon, the sea beast, and the scarlet colored beast are the same 6 historical kingdoms as the foundation image of Daniel 2, with 5 kingdoms or 5 of the 7 heads. Jerusalem was historically related to all of these kingdoms. Jerusalem was destroyed by Babylon. Jerusalem was rebuilt by the Medes and Persians. A Greek king set up the AoD in Jerusalem. The Romans were involved in the crucifixion of Jesus, and saw the end of Jerusalem for hundreds of years, the second time.
The 5th kingdom was not included in Daniel per se. That is why the OP will not address the legs and feet as seperate kingdoms, yet calls them (plural) pagan Rome, and papal Rome, which are historical constructs. Rome was never named at all, in Daniel. We only get Rome from the history books.
Revelation does not cover Daniel at all, except to say: "And there are seven kings: five are fallen, and one is, and the other is not yet come."
These 5 fallen are the first 5 heads. None of these 5 will ever return. Babylon will not return. The Medes and Persians will not return. Greece will not return. And certainly the Romans will not return. Yet all of these kingdoms have descendants that are still viable today. We literally have no Scripture describing the 6th head or kingdom. Except it has a mortal wound and Satan will heal that wound, after the Second Coming. Satan is the 7th head of this 7 headed beast. Satan has been working to influence all these kingdoms starting with Nebuchadnezzar.
Daniel left us with the point:
"As concerning the rest of the beasts, they had their dominion taken away: yet their lives were prolonged for a season and time."
We still have people living today descended from all those nations listed in Daniel 2. We still have people calling themselves Assyrians from the kingdom before Babylon. We still have Egyptians and Egypt who was always a minor kingdom even before Abraham. Abraham came out of the Mesopotamian kingdom.
If God allows it, Satan will be an 8th world wide kingdom, at least over the few tens of thousands of people left on the earth. This 8th kingdom is Mystery Babylon. It is based in Jerusalem on the throne Jesus established at the Second Coming. The 7th Kingdom of Jesus will be put on hold just after the 7th Trumpet declared all nations were now under Jesus' control, 3.5 days later to be precise. The week mentined in Daniel 9:27 is a literal week of days. The midst of the week is 3.5 days. The week of the 7th Trumpet is the end of Gabriel's 70 weeks when the mystery of Daniel is declared over.
But the 70 weeks will not end 7 days after the 7th Trumpet starts to sound, if Satan is given 42 months. The end of the week will be those 3.5 days the 2 witnesses are laying dead in Jerusalem. The same 3.5 days the 7 vials are poured out onto Satan's empire. When Armageddon is over will be the end of the 7th Trumpet, and those 70 weeks of Daniel 9. The Day of the Lord, the Millennial Kingdom will be when those promises in Daniel 9:24 are fully established and experienced. The 70 weeks will be no more and declared over as in time up.
"And sware by him that liveth for ever and ever, who created heaven, and the things that therein are, and the earth, and the things that therein are, and the sea, and the things which are therein, that there should be time no longer: But in the days of the voice of the seventh angel, when he shall begin to sound, the mystery of God should be finished."
Notice John says "should be finished". It won't be finished if time is extended for Satan's 42 months. Time is extended when the Atonement Covenant is confirmed and God states some will be beheaded in the next 42 months, thus still need redemption under the Atonement Covenant. Redemption for those beheaded will not happen, until they are physically beheaded. The 70 weeks cannot end, until all named in the Lamb's book of life are accounted for who are still physically alive on the earth at that point. Only God will know who may or may not be beheaded. While John saw these events unfold, whether they happen or not has yet to be determined by God. John saw the worse case scenario, not the best case scenario.
God told Nebuchadnezzar in the dream Daniel interpreted, when the church would become a great mountain filling the earth. That would be at the Reformation. But no one explained to Daniel the fulness of the Gentiles, nor the Revelation that was given to John after the first coming of Jesus. Daniel saw all the way to the GWT Judgment event, but not the details of Revelation 20, and the Day of the Lord. Daniel was told 3500 years as the time, times, and half a time, but people today still think that means 42 months, 1260 days, or 3.5 years. It is actually 3500 years, from Daniel until the end of creation, when Jesus hands back creation to God.