As others have pointed out, common reasoning behind picking a distro include: hardware requirements, existing ecosystems, end user, package management, configurableness, security, long-term support, ease of learning, driver support, core dev team’s opinions, funding, etc.

Maybe Debian is on par now. Old software can be worked around with containers and third party apt repositories. I often do that on Ubuntu too.