Hi thanks for the A2A, well the best thing with this passage is to look at the translation in the Bible that tell us what the passage says.
Psalm 9:17
Easy-to-Read Version
17 The wicked will go to the place of death,
as will all the nations that forget God.
Psalm 9:17
Names of God Bible
17 Wicked people, all the nations who forget Elohim,
will return to the grave.
The passages above tell you that the wicked are the ones who have forgotten God, and for this they will either die and/or return to the grave. This is a prophecy of the Millennium or how people will live during that time. What passage best supports this concept of how judgement Day commerce?
John 5:28-29
Names of God Bible
28 Don’t be surprised at what I’ve just said. A time is coming when all the dead will hear his voice, 29 and they will come out of their tombs. Those who have done good will come back to life and live. But those who have done evil will come back to life and will be judged.
When you asked in your question if God will destroy countries the answer is yes and no. Yes, as a fact where God’s own government will take over each countries government so that they are gone forever. And no in that God will focus on each person in every country called “the wicked” and they will be destroyed.
Now you asked if people in the future will go to heaven? What information in the Bible tells us where people will always live even those in the future?
Revelation 20:9
Names of God Bible
9 I saw that they spread over the broad expanse of the Earth and surrounded the camp of God’s holy people and the beloved city. Fire came from heaven and burned them up.
Revelation 20:9
Easy-to-Read Version
9 I saw Satan’s army march across the Earth and gather around the camp of God’s people and the city that God loves. But fire came down from heaven and destroyed Satan’s army.
These two translations tell us that life for humans will always be on Earth just as we are right now and that we will never leave it. There is in fact no rapture or what people are thinking will happened. What passage in the Bible tells us about the people living in the future with God’s permission?
Revelation 7:9
Modern English Version
The Multitude From Every Nation
9 Then I looked. And there was a great multitude which no one could count, from all nations and tribes and peoples and tongues, standing before the throne and before the Lamb, clothed with white robes, with palm branches in their hands.
Revelation 7:13-17
Modern English Version
13 Then one of the elders asked me, “Who are these clothed in white robes, and where did they come from?”
14 I said to him, “Sir, you know.”
He said to me, “These are those who came out of great tribulation and washed their robes and made them white in the blood of the Lamb. 15 Therefore,
they are before the throne of God,
and serve Him day and night in His temple.
And He who sits on the throne
will dwell among them.
16 ‘They shall neither hunger any more,
nor shall they thirst any more;
the sun shall not strike them,’
nor any scorching heat;
17 for the Lamb who is in the midst of the throne
will shepherd them
and ‘He will lead them to springs of living water.’
‘And God will wipe away every tear from their eyes.’”