After Shining Armor falls in battle, Luna helps Cadence cope with her grief. With his death, Cadence can no longer escape the harsh reality of her immortality and must come to terms with it.
Twilight, also struck by the truth of her situation, seeks out Celestia, who offers her an answer as harsh as the truth she must face.
Despite the sad tag, I can promise that there are heartwarming moments.