For Paul, death was not something to fear but a transition to something far greater—to be forever with the Lord