Very interesting story and link, relevant to my own research since around 2017, as an already long practicing Systems Engineer, thanks for posting.
I don't agree with the conclusions though. The study looks like a conscious or unconscious attempt to penalise users of "Renewables", for daring to move to energy other than that supplied by the utilities energy industry, which still has massive political clout, when actually those users of specifically solar energy, should be being rewarded. Of course the utilities energy industry doesn't like that its revenues are declining. Something which does not appear to have been taken into account by the study is the effect on, and the linkage with money.
I don't think it helps any scientific case, to create emotive terminology like "Death spiral", this looks like standard click-bait technique to attract attention to their actual agenda, which is to promote the interests of the utilities energy business.
Also the "Aggregator" concept is superseded, as are batteries, if the distributed solar powered communities, instead of generating electricity back into the grid, opt instead to generate hydrogen, using this to back up their own microgrids, as well as supplying their excess to passing hydrogen powered transportation, for example.
On the issue of tax raising for governments, why shoud the government itself not become self powered and funded itself by its own solar hydrogen infrastructure?
For an alternative, arguably more technical view, concluding the opposite of the conclusion talked about here, also taking into account the effects on, and linkage with money, and the value of money, see the story at the link below, as well as most of the 330 odd stories in my profile:
