The tradeoff is that we are pivoting away from work we had been doing on desktop applications and will cease shipping LibreOffice as part of RHEL starting in a future RHEL version. This also limits our ability to maintain it in future versions of Fedora.
We will continue to maintain LibreOffice in currently supported versions of RHEL (RHEL 7, 8 and 9) with needed CVEs and similar for the lifetime of those releases (as published on the Red Hat website). As part of that, the engineers doing that work will contribute some fixes upstream to ensure LibreOffice works better as a Flatpak, which we expect to be the way that most people consume LibreOffice in the long term.
I’m no fan of Flatpak for a multitude of reasons, but at the same time, I can’t blame Red Hat and other distribution makers for not wanting to maintain a complex set of packages such as LibreOffice. This does give me pause regarding my current use of Fedora on two of my three machines, as I do not wish to rely on Flatpak for anything serious.