"Content" is a pretty loose term, I'll grant you that. I think this would require a response from a Cakewalk representative. I would assume loop libraries and expansion packs for instruments would be members only, although I could also see some of them being sold separately to non-members and non-SONAR users.
As to things like my amps, that's up to Cakewalk. I'm planning on doing an amp every month, so there are lots of ways they could be handled...they could be sold as an "Amp Pack" so people could catch up. Maybe Cakewalk would let Platinum owners get all of them, and Artist and Professional users get a lesser amount. Or maybe Cakewalk will be feeling generous and give 'em all away.
I think a lot of the point of membership is you get stuff as soon as it's ready. Whether something that was part of membership becomes available in a year or two for "catch up" hasn't been defined, but Cakewalk does seem to err on the side of generosity.