In a bittersweet return to form, Destiny 2’s final update is giving players reasons to roam its public zones once again