I can safely say with a great deal of certainty that the likes of Logic, Pro Tools, and Ableton Live will be around for a very long time to come. This is simply because they all have a well developed and established niche in the music software market, this breeds confidence in those products and as such, they receive the lion's share of the (ever shrinking) revenue stream.
I work in the education sector here in the UK, delivering music and music tech courses up to degree level. I can't tell you how much we spend on software licenses obviously, but what I can tell you is that it is one of our largest spends, year after year. Can you imagine how much revenue Apple, Avid and Ableton generate through the education sector alone? Worldwide?
It is all about confidence. Pick one of the above and you'll be able to spend your hard earned with confidence, a safe purchase.
I think the wisest advice I could ever give among the sadness and aftermath of Cakewalk's cruel demise, is to learn and use multiple DAW's. There are many of them and they're all great, find a couple that you like and get busy. Then at least, you're covered if anyone should ever try and do a Gibson on you.
Personally I fully intend to use Sonar for many many more projects and feel no need to suddenly move to something else entirely. My system works very well and handles all I could ever need, and so will now be forever frozen in time as my dedicated Sonar Platinum machine.
Try not to fear the change, embrace it. Many creative discoveries await you