Heaven-going at death is a false doctrine not found in the Bible.
We do not possess an immortal soul; we ARE a soul.
Genesis 2:7 And the LORD God formed man of the dust of the ground, and breathed into his nostrils the breath of life; and man became a living soul.
1 Corinthians 15:45 And so it is written, The first man Adam was made a living soul…
Ezekiel 18:20 The soul that sinneth, it shall die…
When we are placed in the grave our soul is placed in the grave.
Psalms 89:48 What man is he that liveth, and shall not see death? shall he deliver his soul from the hand of the grave?
The Bible says that no one goes to heaven other than Jesus Christ, who ascended to heaven 40 days after his resurrection.
John 3:13 And no man hath ascended up to heaven, but he that came down from heaven, even the Son of man which is in heaven.
His residence in heaven is temporary.
Acts 3:21 Whom the heaven must receive until the times of restitution of all things, which God hath spoken by the mouth of all his holy prophets since the world began.
God has appointed a day when Jesus will return to raise and judge the dead and establish the kingdom of God on earth.
Acts 17:31 Because he hath appointed a day, in the which he will judge the world in righteousness by that man whom he hath ordained; whereof he hath given assurance unto all men, in that he hath raised him from the dead.
John 5:28 Marvel not at this: for the hour is coming, in the which all that are in the graves shall hear his voice, 29 And shall come forth; they that have done good, unto the resurrection of life; and they that have done evil, unto the resurrection of damnation (condemnation).
When we die, we remain unconscious in the grave awaiting the resurrection to Judgment.
Ecclesiastes 9:5 For the living know that they shall die: but the dead know not any thing…
Psalms 146:4 His breath goeth forth, he returneth to his earth; in that very day his thoughts perish
Death is therefore described as sleep.
1 Kings 2:10 So David slept with his fathers, and was buried in the city of David.
Acts 7:60 And he kneeled down, and cried with a loud voice, Lord, lay not this sin to their charge. And when he had said this, he fell asleep.
The purpose of God is to fill the earth with his glory.
Numbers 14:21 But as truly as I live, all the earth shall be filled with the glory of the LORD.
This glory will be in the form of faithful men and women raised from the dead and given the divine nature (made equal to the angels) with whom and in whom God will dwell forever.
2 Peter 1:4 Whereby are given unto us exceeding great and precious promises: that by these ye might be partakers of the divine nature, having escaped the corruption that is in the world through lust.
Luke 20:35 But they which shall be accounted worthy to obtain that world, and the resurrection from the dead, neither marry, nor are given in marriage: 36 Neither can they die any more: for they are equal unto the angels; and are the children of God, being the children of the resurrection.
Paul describes what is going to happen on the earth.
1 Corinthians 15:20 But now is Christ risen from the dead, and become the firstfruits of them that slept. 21 For since by man came death, by man came also the resurrection of the dead. 22 For as in Adam all die, even so in Christ shall all be made alive. 23 But every man in his own order: Christ the firstfruits; afterward they that are Christ’s at his coming. 24 Then cometh the end, when he shall have delivered up the kingdom to God, even the Father; when he shall have put down all rule and all authority and power. 25 For he must reign, till he hath put all enemies under his feet. 26 The last enemy that shall be destroyed is death. 27 For he hath put all things under his feet. But when he saith all things are put under him, it is manifest that he is excepted, which did put all things under him. 28 And when all things shall be subdued unto him, then shall the Son also himself be subject unto him that put all things under him, that God may be all in all.
The promise is that of eternal inheritance on the earth.
Psalms 37:11 But the meek shall inherit the earth; and shall delight themselves in the abundance of peace.
Matthew 5:5 Blessed are the meek: for they shall inherit the earth.
May I suggest that you read:
After Death - What? https://www.thisisyourbible.com/library/show/43
Your Share in God's Promises: https://www.thisisyourbible.com/library/show/181
I hope this helps.