The story is great but hear me out, there is a retcon but if you are willing to look passed that, what they do with it makes the big bad feel threatening and the atmosphere very engaging i recommend doing side quests and they show up on your map they help build depth a lot of them are straight to the point.
I am a destiny veteran played since rise of iron i can say this expansion is one of the greats these negative reviews mainly just complain about being resent and the story not being connected to final shape when it was made clear that saga ended.