I don't know if the moderation team's collapse is indicative of anything. The first blog post complains about the Steering Committee for doing, well, steering. The moderators complaining that the Steering Committee is "interfering" points to a bigger issue where the moderation team didn't understand their role.
The second blog post is from someone on the steering committee who complains about Gabriella439 (the author of the 3rd blog post) "turning on" them after they tried to work with the moderation team, whatever that means.
The third blog post complains that the moderation team was too large, had a lot of absenteeism problems, and tried to do everything by consensus which didn't work with the large size combined with the absenteeism problems.
The last post is most revealing. It's also the least dramatic. It looks to me like they tried to form a way too large group of people who treated this as a low priority, then tried to do everything by heavy procedures and consensus with half the team not showing up. That's a common mistake in community organization that leads to collapse.
EDIT: I looked up the conversation about the NixOS moderation team resigning. Apparently the moderation team was causing a lot of their own problems within the community. I'm not going to read it all, but this looks like familiar overzealous moderator drama
My favorite example so far was that someone got banned and one of the conditions for getting unbanned was removing steak from their profile picture: https://github.com/NixOS/moderation/commit/e9d67b7efa03e6e9b...
I think the elephant in the room is that many tech nerds are just famously terrible at working with others and social skills in general, even if they have a long history of excellent work. Especially so if that experience was not gained from traditional careers where it wasn't possible to get by without people skills.