I bought Destiny 2 on launch, a rarity for me these days, because two of my friends also did the same and wanted to play Co-Op. We just couldn't get into it. The campaign was incredibly easy and insultingly short, the enemy AI is atrocious, the tokens and engrams feel mostly unrewarding and boring, the weapon/armor skins and shaders are pretty bland, there are only a handful of dungeons that the game expects you to play over and over and over and over again for little to no reward, and while I had no interest in PvP, the friend of mine who did play it said it was very much "headshots or GTFO."
It's a relatively pretty game to look at, and the gameplay itself feels very solid, but it has a serious lack of meaningful content. I highly doubt the expansion pack adds enough new content to actually justify its price tag, given how lacking the $60 base game was. If anything, Destiny 2 only reinforced my "no day 1 purchases" stance, regardless of what my friends do.
The last time I played Destiny 2, three weeks ago, the experience consisted of doing a single rotation of all of the dungeons in like an hour, doing the weekly nightfall, none of us getting anything useful, then watching one of my friends play with the purple ball at the tower while the other was Alt-Tabbed watching shit on YouTube because we couldn't muster the motivation to do anything else.
Assuming the new DLC actually gates previously available content, I'm surprised anyone even noticed. Judging by my own personal experience with the game, it seems like most of the people still playing are the people who were going to have the expansion pack anyway. Still a shitty practice though, assuming it's true. I highly doubt I'll be bothering to log in anytime soon to check.