It is not the death that is fearful. It is the pain that takes place before the death.
Once you are dead, you can't feel pain. Not unless there is a God and will punish you in Hell.
I am an Agnostic myself. Don't know if there is something called God. If there is this God, then pain will go on in Hell after death. An infinite pain.