In many cases like this they end up selling rights to one of the growing ad-supported streaming services, which means I personally will never watch. I had just started watching Prodigy in the gap between Picard and SNW. I think companies are being shortsighted in cutting back their catalogs in this way since it encourages people like me to cancel subscriptions between the initial broadcast of new seasons of the more popular series rather than stick around for something of perhaps secondary interest.
I am almost a mirror-image of you regarding Reddit, except to me Reddit was Apollo rather than RIF. I too have cancelled Reddit Premium, which I paid to support a platform I used a lot. LIke you I am trying out the fediverse via lemmy, kbin, and mastadon; and, like you, I am enjoying mastodon and using it much more than I ever used Twitter. Finally, like you, I have gone back to RSS feeds and old forums I used before my Reddit habit overshadowed them. And other people I know are doing the same, albeit they tend to be the more techy inclined.
I am always in favor of gettin' real nerdy. This reminds me a bit of the podcast The Lazy Doctor Who, where over time (with no particular schedule) the podcasters post podcasts for every episode in order of Doctor Who. In their case they comment while rewatching the episode. A podcast is different than a community post on Lemmy. However, it might be beneficial to slow down a bit and post less frequently to give people time to watch/rewatch the episode in question as context for your posts and thus encourage more discussion among subscribers, particularly as the community hopefully grows over time.
I also cancelled my Reddit premium. I was using Apollo so the no ad thing was not a factor and I never used my tokens. But I used reddit a lot over many years and wanted to contribute. Currently I am avoiding reddit and trying out Lemmy. Will decide before Jun 30 whether to delete posts/comments/account. I have also resrrected an RSS app which I had not been using for quite a while.