Death is not terrifying. Severus was not afraid of it; in fact, he longed for it. To perish beneath Voldemort's curse was perhaps the finest ending he could hope for.