I needed RSS enough to self-host Fever (on A Small Orange which is a POS that I need to migrate from, if anyone can recommend me a simple and user-friendly alternative).
Similarly, I've been waiting for Pinry to release version 2, but this seems to have eluded the team for a few years unfortunately.
It physically hurts when I see people purge their tweet history, because I can't imagine giving up all that history, especially when you can at least export your stuff first - which doesn't include your likes and DMs.
I don't think the latest Instagram/Facebook/Twitter brouhaha has been a vindication for RSS per se, but definitely one for self-hosting, especially as services die or get acquired left and right.
You might be cute and argue that for RSS being such a big deal, there sure aren't any overnight successes 15+ years in the making to migrate to at this point. I know Maciej Ceglowski of Pinboard fame was working on an RSS reader, but that seems to have stalled. And Digg just shut down theirs, which was really good. Fever is also shut down, but that doesn't matter much when it's self-hosted - except for the crazy fees ASO is charging people like me.