Oh yeah, spoiler alert for Destiny 2: Forsaken or something. Not that it matters since Bungie themselves straight up shows the serial punster getting blasted in the face by Prince Emo* (*actual name Uldren Sov).
The Reef has fallen to lawlessness, and now the most-wanted criminals in the galaxy – the Barons & Uldren Sov – have organized a jailbreak at the Prison of Elders. You and Cayde-6 have been sent in to bring law and order back to the embattled facility, but things do not go to plan. Facing insurmountable odds, Cayde-6 ends up paying the ultimate price. Beyond the Vanguard’s authority, you’ll venture into the Reef alone and take justice into your own hands. Explore new regions, awaken new powers, earn a wealth of new weapons, and uncover lost Awoken secrets. The hunt is on.

• Hunt Down the 8 Barons and their Crew
• Two New Destinations: The Tangled Shore and The Dreaming City
• A Brand-New Raid
• Introducing Gambit, a 4v4 Competitive PvE Mode
• Wield New Powers with Nine Additional Supers
• Collect New Exotic Weapons, Armor, and Gear
• All-New Weapon Archetype, Legendary Bow
• New Story Missions, Adventures, Destination Activities, and more

Destiny 2: Forsaken will be released on September 4. If you pre-order now, you get Cayde's Exotic Stash. I'm assuming he just gives it to you in his will or something. Or, since he's a robot and all, they probably just put his memory into another robot body and he gives his old stuff to you as thanks. You know, whatever works best since I really doubt they'd kill off a central character like that.