There was little Bungie could do about the PS4 era hard drives being so tiny.
In retrospect, Beyond Light and after should have been Destiny 3, available only for PS5-era systems, with some seasonal passes stretching out D2. Portray zombie-D2 as being a Vex simulation with the real world being D3, with an option to port your D2 chars whenever you moved to D3.
Obviously, there would have been huge downsides to that plan as well. Would the PS5-era launch player base have been big enough to support a new game? Would players buy a Destiny 3 that was at that point 90% reused Destiny 2? Wouldn't Bungie have the same upkeep issues as they claimed back then, just in D3?
But at the end of the day, there's only so much you can do with having a live game on ancient hardware. I believe FF14 has all but said its days on the PS4 are numbered as well.