The mistake that stalls most Lightroom migrations is hunting for a single program that does everything Lightroom did. On the open source side, RAW development and library management are usually separate concerns. darktable is the closest to a combined tool, pairing a non-destructive darkroom with a database-backed lighttable for browsing and rating, while RawTherapee goes deep on demosaicing and tone control but deliberately leaves asset management out. Decide first whether you want one application for both jobs or a developer paired with a separate library.
The other half of the choice is where your photos live and how you reach them. If your priority is developing individual frames with precise control, a desktop editor like darktable or RawTherapee is the core of the workflow. If it is browsing, searching, and sharing thousands of images across a household or team, a self-hosted gallery fits better: PhotoPrism, Photoview, and LibrePhotos index folders you already keep and add face recognition and search, while Damselfly is built around fast keyword tagging over large libraries. Many photographers run one of each rather than forcing a single tool to do both.
Whatever you choose, prepare the library inside Lightroom before you move. Write metadata to files so ratings, keywords, captions, and GPS data travel as XMP sidecars, and export finished JPEG or TIFF versions of your most important edits, because develop instructions, masks, and history will not survive the jump to a different engine. Import one representative folder first and confirm that the rendering, not just the file, is what you expected.