I'm not as afraid of being dead, so much as I am most afraid of the short time before. Knowing that I'm dying, that soon I will be dead.
And also the finality of it. Pre-birth ended with my birth. Death will never end.
But you actually can be afraid of death, even though death doesn't come with any negative experiences, because you can and do care about things besides anticipated experiences. It's a common misconception that you can only care about experiences, but the counter to any conceptual argument that purports to prove that is that you do in fact care about some things that aren't experiences, death being a great example.
My friend Ronny discusses this at some length in this podcast https://clearerthinkingpodcast.com/?ep=032
As far as we know. It seems logical based on our existing knowledge, but really, anything can happen.
Certainly we’ve never seen someone come back from the dead in recent history.
He was meant to slay dragons, but terribly afraid of getting eaten in the process.
It kept him up at night, he asked people how to cope with the stress and got plenty of advice, to which he replied the suggestions don't address his actual problem.
No trick dispels. Religion used to try,
That vast moth-eaten musical brocade
Created to pretend we never die,
And specious stuff that says No rational being
Can fear a thing it will not feel, not seeing
That this is what we fear—no sight, no sound,
No touch or taste or smell, nothing to think with,
Nothing to love or link with,
The anaesthetic from which none come round.
—Philip Larkin, Aubade
(italics original)
Dying looks like it’s probably not going to be fun. But, I’m not worried about being dead.