For me it’s pretty simple:
-older hardware/no need for up to date packages - Debian
-new hardware, needs up-to-date software - Arch
And that’s it. Though obviously, you can also use flatpak if you truly need newer versions of software. Personally I have arch on my gaming PC + Debian on my multimedia-consumption laptop.

It’s really weird how Mozilla is trying to market to the punk-anarchists and the AI techbros at the same time. It won’t work.