Sony was never going to fix Bungie. Bungie has a history of poor management since the Halo days.
I don’t think we’ll see them replace leadership at Bungie unless there’s another “missed profit projections by 45%” incident. We also don’t know the full story behind Joe Blackburn leaving. Could be he was burnt out. Could be he was forced out due to poor sales. People in top positions like his tend not to get fired but given the option to quit.
I’d also argue that Bungie has been making mostly good decisions and adding good features to the game since at least Witch Queen. Hell, they just undid sunsetting which I thought would never happen.