So what is the dumber down version of LR... elements?
And is it a stand alone or also a monthly fee?
There is not really an alternative to Lr that is dumbed down. You may find that the image management component that is now shipped with Ps Elements may do that job, but there is a good chance that you may find PsE limiting after PSP. PsE has essentially no 16 bit support, other than converting the file to 8 bit. So it depends on your level of PSP use. I haven't used PsE since V2 that came with my 300D, and given how bad Canon's own RAW converter was back then I quickly became a RAWShooterEssentials/PsE user. I had a bit of a look at PsE 6 when it came out, but only on behalf of someone else.
"While you may continue to purchase and use Lightroom 6 with a perpetual license, Adobe will no longer provide updates to the software. "
So am I better off going with the CC version in the long run?
If you are not going to plan on replacing either your computer or your camera for a couple of years then going with Lr6 might not be a bad idea. Although it won't be updated you should be able to continue using it without issue. The only issue is if your OS is updated and no longer supports the old version of Lr.
Alan
This is right up there with should I use a protective filter. It is all good. That is the beauty of having choices. 
