This discourse post has more details. Essentially: Nixpkgs is an 83 GiB repository with 20,000 forks that incurs a ton of API usage from CI and bots. It turns out this caused some scaling issues. It's unclear to me if other forges would have run into exactly the same issues but if the repo can cause replication failures at GitHub it can almost certainly cause problem at Codeberg.
Edit: For comparison, the Gentoo repository is 20 GiB and has 2.2k forks (on GitHub). The largest repository on Codeberg is 30 GiB, but that's just a blocklist data mirror with no CI.
Edit 2: Also, since I'm reading through Gentoo's mail archives for this they also seem to be at least slightly worried:
So far I don't think we really deliberated on [using Codeberg for the sync-friendly mirror]. The key point here is that unlike GitHub, Codeberg is running on community funding, and we don't want to abuse their resources with the huge syncing repo.
Note that Nixpkgs doesn't have a syncing mirror. Majority of Nix users pull directly from github.com/NixOS/nixpkgs.