“Now, I know that as a Christian, this world is not our home and we are destined for glory upon glory into the eternal realm ...”
You have some explaining to do ...
“The righteous will possess the earth, and they will live forever on it.”—Psalm 37:29.
Psalm 37:29 (ASV) The righteous shall inherit the land, And dwell therein for ever.
Psalm 37:29 (BBE) The upright will have the earth for their heritage, and will go on living there for ever.
Psalm 37:29 (CEBA) The righteous will possess the land; they will live on it forever.
Psalm 37:29 (CJB) The righteous will inherit the land and live in it forever.
https://www.biblestudytools.com/psalms/37-29-compare.html
Who is the audience the Psalmist is addressing?
Christians weren’t around when it was written.
You have some reading to do. Read Revelation chapter 21. The earth will be recreated.