First, take a deep breath and relax. You said "I did see it in my products, but it indicated it was a "membership product" and that my subscription expired and I needed to renew." That means your version of SONAR and all the updates for one year following the purchase are there for you to download and install. The "membership" was for one year and included any updates during that time. You can download the software from the "My Products" page and install it using off-line activation or you can download the Command Center and install and activate your software through it. Either way, you haven't lost anything that you paid for. Its there - just download it and install it.
BTW, it was not a subscription like with Adobe products or Office 365. With their software when you stop paying you no longer have use of the software - ever. With Cakewalk, you had the option of paying all at once (as you did) or paying once a month for 12-months (an even monthly payment plan). But once you were "paid in full" the version of the software was yours to keep, plus any additions/updates for one year from date of purchase. So the software is really yours. That is different from the subscription model.
Good luck, and keep an eye on the forums. A lot is happening with the acquisition of the Cakewalk IP by BandLab. Look for new stuff in the coming weeks and months ahead.