Act 23:6 But when Paul saw that the one part were Sadducees and the other part Pharisees, he cried out in the sanhedrin, Men! Brothers! I am a Pharisee, the son of a Pharisee! I am being judged because of the hope and resurrection of the dead.
The "hope of the resurrection of the dead" speaks to:
Rev 20:5 But the rest of the dead did not live again until the thousand years were finished. This is the first resurrection. Rev 20:6 Blessed and holy is he who has part in the first resurrection. The second death has no authority over these, but they will be priests of God and of Christ, and will reign with Him a thousand years. Rev 20:7 And when the thousand years have expired, Satan will be loosed out of his prison. Rev 20:8 And he will go out to deceive the nations which are in the four quarters of the earth, Gog and Magog, to gather them together to battle. The number of them is as the sand of the sea. Rev 20:9 And they went up over the breadth of the earth and circled around the camp of the saints, and the beloved city. And fire came down from God out of Heaven and devoured them.
None of this makes sense if you die and go straight to heaven or hell. None of it. Insult me all you want to, it does not change the facts.
Revelation is referring to the spiritually, not the physically, dead. Paul before the sanhedrin is speaking of the bodily resurrection. Not the state of the spirit after death. You need to read I Thes 4:13-17. Particularly vs 14.