I’m coming at it from the opposite side; social media isn’t a reasonable alternative to RSS, but people often use it as such. RSS is as you say, for getting updates from specific sources without being at the mercy of a third-party’s recommendation algorithm.