Just an observation from me. Death is often called sleep in scripture. But sleep is not total unconsciousness. Nor is even a coma come to think of it. We are unconsciousness in a sense when we sleep. And then we rise again every morning refreshed, perhaps a beautiful parallel every day that one day out of ‘true sleep’, of which our nightly sleep is just a shadow, we will rise from the dead refreshed. Even in sleep though we dream, we move, some even walk. Some say that the process of resting and dreaming cleanses the body and the mind. It makes me wonder if death is called sleep because it is, in the spirit world, a similar process. That our spirit isn’t conscious, much like when we sleep, but that there is still something ‘going on’ with our spirits, like when we dream. That our death-sleep is a time that the spirit interacts in some way with God, in a parallel to our dreams, but is still needing to be united to a resurrected body in order to be a living soul that praises God. It would make sense to me too, why necromancy was forbidden. It was possible to call a dead ‘sleep walker’ up from their rest, but you are not supposed to. The spirit is to be resting and refreshing with God, awaiting the day of resurrection.
This is just me throwing thoughts out there. I have no formed opinion on this topic. But it seems to me there is more going on here than we realise.