To be honest I don't really feel in any particular way about Concord failure, what I see is:
-They didn't make a lot to market the game, in every EVO break you were able to watch a trailer of Astrobot, Concord was there mostly only in finals day.
-Astrobot had a big emphasis at EVO, Chinajoy and will at TGS, Concord didn't.
-They paid for streamers to play the demo but not the game at release date, they did with Helldivers 2.
-In the PS Japan trailer of games for the second half of the year they put Valorant a game that is ultra popular in Japan, Concord wasn't in the trailer.
What I'm trying to say with this is that they knew this game was going to fail so it's not like this is a surprise for them and the new CEOs probably already have a plan in mind.
The good part about this is that Concord is a double confirmation of how dangerous services are and this will help shape the future of the company. Many sites and people on the internet are acting like this is the "new PlayStation" like they didn't know that even before the release of Returnal (2021) the plans of releasing 10+ service was already a thing and the Bungie meltdown finished those plans. The only thing left to do is wait and see what the new administration will do to clean Jim Ryan shitshow.
If it was me I would respect the people who already bought Concord, give the game a year or two, in the meantime make Firewalk help finish Haven game and also help Bungie, you already bought the studio so get some use from it, put Concord on PS Plus vanilla and hope the Lost Levels episode of Concord awakes some interest in the game, once Bungie in completely integrated with SIE (this will happen sooner or later, probably next year) merge Firewalk with Bungie as a new team inside the studio, after all they have said the synergy between Firewalk & Bungie is big (because Firewalk was made with ex Bungie) and in the middle of the merge fire whoever thought Concord designs were good.