Nobody panic.
Correct, SUSE, the corporation is no longer providing a traditional linux distribution, after the SLE-15 EOL.
openSUSE, which is a community project, and not controlled by SUSE, is currently debating as to whether we have the contributors interested in doing so, and in sufficient numbers, to continue to provide a traditional point release distribution.
Tumbleweed (the rolling release) is not going anywhere. The community has not yet decided if the interest and manpower is there to use the ALP sources provided by SUSE to create A) A traditional linux distribution, akin to what Leap currently is, B) a "Slowroll" version of Tumbleweed, that has a slower release cycle, or C) Nothing at all, because there isn't the community there to support the development of it.
SUSE != openSUSE
That is indeed the big question, if there's nobody willing to put in the work, then there's nothing to release.
Maintaining something like Leap, with the contributor base that has historically existed, isn't sustainable, long term, especially when the upstream is going in a different direction.
I don't care about beeper one way or another, but that bloody image with the post, it needs to die in a fire.
I will never claim they are authentic, or even great, but I will destroy the 2 for a buck tacos.
Mostly because they're uneducated fools, that haven't any actual idea what the hell they're talking about.
Unless you're pulling sources, and building everything yourself, everything you get from most major distributions is "pre-compiled".
People hate anything new, they fear change, and they like drama, that's all it is.
Fedora Silverblue or openSUSE Aeon, I'd probably say.
The dsektop environment really doesn't have anything to do with it. That's up to the video drivers and display server, be it X11 or Wayland. I haven't any idea which desktop might offer you the best tools for configuring those things though. Just as a rough guess, I'd guess KDE Plasma, perhaps XFCE?
I'd probably drop openSUSE Tumbleweed with LXQt on it. But that's my preference for low-spec machines. There's any number of distros with "lightweight" GUI's that you can use. XFCE/MATE/LXQt probably being the ones that will give you the least headaches.
I have no idea who signs his paychecks, but no, none of the announcement about the RHEL Sources affects Fedora in any way, unless Nobara is pulling sources from RHEL (which it isn't) this doesn't affect it at all. Nobara isn't an official Fedora, or RedHat product or project.
No, nothing RedHat is doing affects Nobara. Nobara is based on Fedora, which is upstream of RedHat. Nothing is changing.
Honestly, I wouldn't make any specific recommendation. Because when you do, you instantly become most peoples personal support technician, when they can't sort something out.
I'd probably make the general suggestions of Fedora/Silverblue/Kinoite, openSUSE Tumbleweed/Aeon/Kalpa, and maybe Pop!_OS if somebody put a gun to my head. But no recommendations.