From what I remember it's not exactly F2P? They do offer a base version without any of the latest content. But if you want to keep up with the latest expansions you need to purchase them. And even so, they still nickel and dime you with microtransactions. Plus they also used to sell lootboxes, which they now seem to have dropped.
Another interesting thing about the Sony purchase is the fact that Bungie will still remain self-funded. It'll be interesting to see what exactly do they get out of it in the short term, if they're not offering funding. I assume they'll leave them to also manage their own profits?
Destiny 2 has been fully F2P since 2019.
Like I said, it's not any different from other F2P games. They all nickel and dime you. That's the whole point.