Most deaths are associated with pain. But I believe that's not why people are afraid of death.
We are afraid of death because we aren't sure we have done enough and the judgment scares us.
Christians therefore must work hard for God with joy even to the last breath but not out of fear of death. Non-Christians should be afraid because of the uncertainty, even emptiness which awaits.