Hmmm did a search for the song I meant
https://www.allmusicals.com/lyrics/s...notdeadyet.htm
But I found many songs by different artists and centered around waking up and finding oneself alive (after a DDG search for not dead yet lyrics)
Seems to be a quite common discovery.