Their desktop products are Red Hat Enterprise Linux Workstation, Red Hat Edge, and the Red Hat Universal Base Image build system. The former is used heavily in particle physics laboratories (CERN and Fermilab use a mix of RHEL, Alma, CentOS) as well as some niche graphics workstations. The latter two are used for a lot of different things, but can be used to manage automatically-updating company-assigned desktops/laptops, and the tools behind it have been extended by the community to offer consumer-grade desktops like UBlue.
They have deep involvement in a ton of different Linux desktop technologies. They also package the Red Hat Flatpak repository, which is the RH equivalent of Fedora Flatpaks. These are Flatpaks that are built by combining the RPM build process with additional flatpak-specific metadata. There is ARM support for all of this, unlike Flathub which is spotty on non-x86-64 architectures. Currently RH Flatpaks is a "tech preview" feature of RHEL9, but it will likely be more fleshed out in RHEL10.
To say it was like this in 20 years ago and I doubt it has changed is pretty crass. Especially for such as Desktop Linux which is essentially unrecognizable from 20 years ago.
https://www.redhat.com/en/technologies/all-products
I see cloud, OpenShift, SAP, embedded, servers, desktop not really.