Internally, big sites like birdsite are massively distributed databases.
Look at the federation bugs you see on #fediverse. Delays. Glitches. Missing posts.
Twitter has the same issues, because these are fundamentally hard computer science problems. The tinfoil hat brigade sees censorship and conspiracies, where people who know how these things work just see the expected bugs.