That is going to stop. I've been on Fedora non-stop since Fedora 17 (and a few times distro hopping before that) and 3 days ago I would have said there's no way I'd consider switching. But I'm putting serious thought into it. I'm going to wait and see how this shakes out, but if the end result of this is that there isn't a workable free RHEL clone, I might just switch. I don't like the Debian way of doing things, but I don't see any other viable options for running the same thing on both local and server. It's really too bad there isn't an Arch server version :-D
I also had the unfortunate experience of just moving one of my servers from Debian to Alma Linux to match my desktop, but I'll likely rollback now.
For enterprise Linux at least.
On my home systems I usually use Alpine or Arch, both of which are distinctly unlike both Debian and RHEL.
I suppose that's really a matter of taste though,
Yum/DNF are _extremely_ featureful package managers.
They have many nice capabilities, a higher degree of logging, etc.
However, they're complex and slow. From the UX side of things, RHEL-like distro's seem to put the most focus on ease of use/vring a complete system out of the box.
Arch/Alpine focus on a being much lighter, in the UI, default packages, and distro config. I would probably classify Arch/Alpine as their own minimalist family of distro's
Our k8s containers are generally either the build-tool's default (usually ubuntu or debian) or we specify the alpine version. You are right though, for containers, caring about the distribution is generally not a concern.
I've used Fedora on my personal workstations forever it seems. But, spend enough time in linux-land and you'll find out there's two very different ways of doing things. There's the Debian Way, and the Red Hat Way. You tend to want to know one really well, even if you can "get by" on the other. (yes, other ways do exist - but they are much more niche)
So, if my servers go Debian (and/or derivatives), so will my personal workstations.