o.k. I think I understand you better now. You believe that we need our old physical body to be revived in order to live on the physical earth, and primarily this makes sense to you because God created us as physical beings in the first place. Yet at the same time, you believe that we are alive in heaven while we wait for the physical bodies to be re-animated. (which means we don't actually die, which in my mind also means we don't need to be "resurrected", but let's put that aside for now)Maybe I'm not explaining well enough, so I will try again.
The spirit or breath of life we receive from God is given eternal life that can never die when we are born again. But our flesh is still mortal, and corruptible. Since neither flesh and blood nor corruption can inherit the Kingdom of God only our physical flesh needs to be resurrected and changed from mortal to immortal and corruptible to incorruptible.
Our spirit or breath of life is already ETERNAL and needs only an immortal & incorruptible body of flesh to be whole again. Our spirit does not itself become immortal & incorruptible but the body our spirit indwells does.
When in physical death our spirit leaves our body, as a spiritual body it ascends to heaven ALIVE. There are verses that indicate that in heaven we sing praises and worship the Lord, so no I do not believe the spiritual body has no consciousness. Else why would Christ say that whosoever lives and believes in Him shall never die?
Whatever you believe the new heaven and earth symbolize of old, I believe the new comes down from heaven after the first heaven and earth passes away. The holy city new Jerusalem is the Church as it exists in heaven that is prepared as a bride (Church) adorned for her husband.
The Scripture tells us we shall have both eternal life as well as immortal life in the age to come. Since our body will be immortal and incorruptible I cannot fathom them not being physical, as humankind was in the beginning when God created man. Just as in the beginning the earth was created for humans to dwell, so too the new earth will be made new again for humans with spirit + body = living souls (humankind) will one day dwell with Christ physically forever.
Although I still see obvious flaws in your logic, at least I now have a sense of your logic, beyond simply "this is what I believe because I've always believe it", but since you said that a physical ultimate reward makes sense to you, let me counter your logic with this:
As you know, the old testament is full of types, that were eventually replaced by better, spiritual versions of themselves.
- Noah's ark was a physical saviour, foreshadowing Christ, our spiritual saviour.
- The old Jerusalem was a physical city, foreshadowing the body of Christ as the new spiritual Jerusalem.
- Israel, the nation of God, was a physical type, foreshadowing the spiritual "Israel of God", of which all believers are citizens.
- The temple sacrifices were foreshadowing the ultimate sacrifice of Christ.
- The temple building itself, which was the physical connection between heaven and earth, was replaced by Jesus Christ, our new spiritual connection to heaven and earth.