I have used Lightroom for 8 years now, since V4 and at present I'm on Adobe's Photography subscription plan, which is € 12.09 per month here in The Netherlands. I use a Mac since 2016 and a Windows machine before that. My catalog contains around 60,000 raw files, which seems well below what Lightroom can handle. For the last few years I have toyed with other raw developers like Capture One, ON1, Iridient etc. but I invariably decided to stick with LR/PS (Lightroom/Photoshop): I'm used to it and am happy with the results, so these days I'll simply ignore other programs until I start to get uncomfortable with LR/PS. Processing in Lightroom suffices for over 95 % of my pictures, and only some of them are taken to Photoshop when I need something LR can't do; most of the time it is about color processing in selected areas which LR sadly lacks.
Many people are strongly opposed against Adobe's subscription model. I'm OK with it, I pay € 150 per year and I'm always up-to-date. Many other raw developers aren't free either and often require you to update at a cost to get the latest features and raw compatibility for newer cameras. And I'm indifferent to the idea of owning software: it's an illusion to think it'll work forever, because a new computer with a newer operating system might break it.
Switching to another raw developer is a painful process, if you have a lot of work done: the new program in general won't honor the processing you did in the old program, or at least not in exactly the same way. I don't look forward to having my work on 60,000 raws obsoleted, even if I can export them to jpegs before switching. So effectively you're locked in to the raw developer you have used and the question becomes which supplier has the best long-term business perspective. My bet is on Adobe (obviously), but in general you should choose a solid supplier with a proven track-record IMHO. As an illustration, I used Nikon's Capture NX in 2008 and 2009 and when I want to revisit raws from that time, I simply redo the processing in LR; I briefly tried the present version of Capture NX (or whatever it's called now) and wasn't successful at recovering my old work.