That's a very interesting and useful read, albeit also really long, but worth it. I think that the mindset of people coming from Reddit (myself included) is different than the people from Twitter. Reddit itself is a weird paradoxical "huge niche" of people who tend to be less conforming and slightly more educated on tech. However, it is true that the Fedi community should make some compromises to really be welcoming and support newcomers, and the tecnical side should change to make it more viable in the aspects that this post outlined. Perhaps some under the hood optimizations and centralization compromises where smaller instances can depend on bigger ones like a tree instead of connecting to every single other instance.

My point is, the Fediverse will probably never be mainstream, but has a shot at being "big enough". However this shot depends significantly on the people running it and the community at large making compromises at least as big as the ones newcomers make when joining to find a middle ground, which may not happen.