I think that Destiny 2's biggest problem is the monetization model. They made the story be money and the grind free. It's such a shame since the feel of the combat in d2 is my all time top for gun combat.
New players come in, decide to try the free stuff to see if they like the game, get bored of the grind, and don't stick around or pay for the story.
The story is what hooks people. Other games where the story/campaign hooks people have two categories.
Category 1: lump sum payment for everything. Example: baldur's gate 3. This is the classic method where every player experiences the hook.
Category 2: free story, pay for the grind. Example: Genshin Impact. A method that most gacha's use, every player experiences the hook, get drawn in, and stick around for the grind as they wait for more story to drop in future updates.
The main problem is new players can't come in and figure out what the fuck they're doing because Bungie literally removed all the starter content and the on-boarding is literally nonexistent. I had a veteran player try to help me get into the game and it was still nearly impossible, I was just so lost because there's nowhere to start, and it's not obvious what content is worth doing.
I can't get hooked on the story, I don't know where it starts.
Yup. With the current model, only the most recent content really matters as players start with a high base power level. You don't need to do the old content with all that story (and now you can't at all) to get up to the latest patch. It's... "friendly" in that aspect, but I've introduced a few people to destiny and I've had to spend hours just to explain things the game doesn't. I've stopped recommending it since they removed the old xpacs.
Meanwhile a game like FFXIV makes you play through the entirety of every expansion before you can get to the latest, a feat that took me nearly 200 hours of gameplay. That's not great if your friend wants you to do end game raids and stuff, but the fact that they haven't removed any old content and it's actually easy to find people to group with is fantastic.
FFXIV was overwhelming at first but once I got into the groove around the second expac or so I really started to love it, and felt like the story was all worth experiencing.
Destiny with the red war campaign was new player experience at its best. Aside from the expansion system. Now they removed all the good story build up and new players are just thrown into whatever