The Bible is clear what is happening when we are dead:
Deuteronomy 31:16 - And the LORD said unto Moses, Behold, thou shalt sleep with thy fathers; and this people will rise up, and go a whoring after the gods of the strangers of the land, whither they go to be among them, and will forsake me, and break my covenant which I have made with them.
2 Samuel 7:12
And when thy days be fulfilled, and thou shalt sleep with thy fathers, I will set up thy seed after thee, which shall proceed out of thy bowels, and I will establish his kingdom.
Job 7:21
And why dost thou not pardon my transgression, and take away my iniquity? for now shall I sleep in the dust; and thou shalt seek me in the morning, but I shall not be.
1 Kings 1:21
Otherwise it shall come to pass, when my lord the king shall sleep with his fathers, that I and my son Solomon shall be counted offenders.
Job 7:21
And why dost thou not pardon my transgression, and take away my iniquity? for now shall I sleep in the dust; and thou shalt seek me in the morning, but I shall not be.
Psalms 13:3
Consider and hear me, O LORD my God: lighten mine eyes, lest I sleep the sleep of death;
Psalms 30:9
What will you gain from my death? What profit from my going to the grave? Are dead people able to praise you? Can they proclaim your unfailing goodness?
Psalms 76:6
At thy rebuke, O God of Jacob, both the chariot and horse are cast into a dead sleep.
Isaiah 57:2
Those who live good lives find peace and rest in death.
Jeremiah 51:39
In their heat I will make their feasts, and I will make them drunken, that they may rejoice, and sleep a perpetual sleep, and not wake, saith the LORD.
Jeremiah 51:57
And I will make drunk her princes, and her wise men, her captains, and her rulers, and her mighty men: and they shall sleep a perpetual sleep, and not wake, saith the King, whose name is the LORD of hosts.
Daniel 12:2
And many of them that sleep in the dust of the earth shall awake, some to everlasting life, and some to shame and everlasting contempt.
In the New Testament we see
Matthew 9:24
He said unto them, Give place: for the maid is not dead, but sleepeth. And they laughed him to scorn.
Matthew 27:52-53
And the graves were opened; and many bodies of the saints which slept arose, And came out of the graves after his resurrection, and went into the holy city, and appeared unto many.
Mark 5:39
And when he was come in, he saith unto them, Why make ye this ado, and weep? the damsel is not dead, but sleepeth.
Luke 8:52
And all wept, and bewailed her: but he said, Weep not; she is not dead, but sleepeth.
John 11:11-14
These things said he: and after that he saith unto them, Our friend Lazarus sleepeth; but I go, that I may awake him out of sleep. Then said his disciples, Lord, if he sleep, he shall do well. Howbeit Jesus spake of his death: but they thought that he had spoken of taking of rest in sleep. Then said Jesus unto them plainly, Lazarus is dead.
Acts 7:59 -60
And they stoned Stephen, calling upon God, and saying, Lord Jesus, receive my spirit. 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.
Acts 13:36
For David, after he had served his own generation by the will of God, fell on sleep, and was laid unto his fathers, and saw corruption:
Ephesians 5:14
Wherefore he saith, Awake thou that sleepest, and arise from the dead, and Christ shall give thee light.
1 Corinthians 11:30
For this cause many are weak and sickly among you, and many sleep.
1 Corinthians 15:6
After that, he was seen of above five hundred brethren at once; of whom the greater part remain unto this present, but some are fallen asleep.
1 Corinthians 15:18
Then they also which are fallen asleep in Christ are perished.
1 Corinthians 15:20
But now is Christ risen from the dead, and become the firstfruits of them that slept.
1 Corinthians 15:51
Behold, I shew you a mystery; We shall not all sleep, but we shall all be changed,
1 Thessalonians 4:13
But I would not have you to be ignorant, brethren, concerning them which are asleep, that ye sorrow not, even as others which have no hope.
1 Thessalonians 4:14
For if we believe that Jesus died and rose again, even so them also which sleep in Jesus will God bring with him.
1 Thessalonians 4:15
For this we say unto you by the word of the Lord, that we which are alive and remain unto the coming of the Lord shall not prevent them which are asleep.
2 Peter 3:4
And saying, Where is the promise of his coming? for since the fathers fell asleep, all things continue as they were from the beginning of the creation.
And when we will come out of the grave, it is at the resurrection, not when we die.
John 11:24
Martha saith unto him, I know that he shall rise again in the resurrection at the last day.
Acts 4:2
Being grieved that they taught the people, and preached through Jesus the resurrection from the dead.
And what Christ himself tells us will happen to those who have died, the resurrection of the just, and the resurrection of damnation for the wicked.
Luke 14:14
And thou shalt be blessed; for they cannot recompense thee: for thou shalt be recompensed at the resurrection of the just.
John 5: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.
These text clearly show we stay in the grave with no thoughts, and clearly do not go straight to heaven or float in spirit bodies and dwell Gods presence, to say nothing of the wicked who will stay in the grave till the lake of fire.