It will stop working if you ever get a new camera. RAW formats are all different and Lightroom needs constant updates to support new camera models. It's a huge mess, the camera companies don't make the specs public and the formats change subtly with camera releases. Adobe obviously gets access to the formats, but open source tools are left to guess and it shows.
I just had this burn me when I got a new camera (Panasonic GH4) and I couldn't import a thing. Even worse is that I was on a road trip and didn't have a way to install the software that came with the camera (also terrible, but I took photos at Yellowstone and badly wanted to see them). As of the last week an update came out and now I'm good to go, but if you want to remain on an old version of Lightroom it can indeed be tricky.
None of the other programs you mentioned are anywhere close to Lightroom. For example, while RawTherapee can technically open images from my new camera, it displays them incorrectly. They're not even the right size and I don't want to talk about color.