Its strongest hold is definitely in Podcasting. Right now, thats basically all a podcast feed is, its an RSS feed. This is largely due to the hands off nature that Apple had with podcasting for so long, though Spotify[0] is trying to wrestle this control over the ecosystem in moving away from publishing an open RSS feed.
Its very much alive in this way though, at least for now, and I think its important to recognize the role of RSS in keeping podcast distribution fairly uniform and relatively meritocratic. I think this why it has exploded as a medium, in part. Its also why you get such a fantastic selection of great third party players.
Unfortunately, I think RSS for news is already past its prime, though alot of "indie" sites and blogs still do have feeds it seems.
[0]: https://singhkays.com/blog/how-spotify-is-killing-the-open-p...