LibreOffice is a powerful free and open source office suite, used by millions around the world.
Why 2 different versions of the same "LibreOffice Community"? Is that not super confusing?
There are always two versions, the fresh latest with newer features ("If you're a technology enthusiast, early adopter or power user, this version is for you"), and the still one ("This version is slightly older and does not have the latest features, but it has been tested for longer") for more cautious users. Citations from https://www.libreoffice.org/download/download-libreoffice/
But then why not name them differently? Like beta or test or whatever?
They are not beta, they are not test, betas of a to-be-new release are released before a version is released as fresh. And once a new version (e.g. 24.8) will be released, it will become the fresh version and the so far fresh (24.2) version will become the still version. Naming and then renaming releases in between would be even more confusing; that actually was done in the past by having Fresh and Still names but people didn't grok the rotating scheme so now just version numbers are used.