I have mentioned before in a previous thread, in the life of St. Martin of Tours, some girl died unbaptized. The monks knew that she was not baptized. They kept her body in the monastery for six months and prayed to St. Martin. St. Martin showed up at the monastery, raised the girl to life, baptized her, and she died.
Where was the girl's soul during these six months? If she had baptism of desire, then why water baptism?
Yeah, good question. Was she in a holding place like Limbo? Or was here soul still somehow attached to her body, where she was in a state like that of coma?
If I recall from the St. Peter Claver story, the woman who had been raised said that she was in some beautiful place, filled with light, but then was told she couldn't go any further.
There are probably many different areas and regions in the after-life or after-world, but God simply did not reveal all the details. He didn't even reveal Limbo of Infants, as that was the result of theological speculation. God probably very deliberately emphasized the extreme tortures of the deepest Hell vs. the ineffable bliss of Heaven as the two poles, since a gray area would hardly incentivize most people from committing sin and doing evil, and only the fear of the extreme sufferings of Hell would have that effect.
While these need to be taken with a huge grain of salt, many people in these NDEs report being in places of great natural happiness, peace, and love ... but obviously they would not have entered the Heaven of the Beatific vision. Some stopped at these gates, beyond which presumably was Heaven proper and the Beatific Vision. St. Paul went to the Third Heaven ... but it didn't appear as though he experienced the Beatific Vision, since I don't believe you "come back" from that, and he would have tried to relate that in his Epistle. SO there are more things in Heaven than are dreamt of in our philosophy.