Debian technically has the same issue but people who want Debian usually stick to stable + backports so it’s less frequent.

Yeah that’s why distributions which put all their community packages in one place with the same dependencies are more resilient in this respect.

Arch’s AUR is not perfect either, you can have packages that list dependencies badly or replace core packages so you can still mess up but in a different way.

NixOS seems to have hit on a very robust formula that lets packages coexist with minimal friction.