It is not at all relevant any more. It will only be "revived" when top browsers and websites support it. The biggest website that I know that supports RSS is (old) reddit, and the biggest web browser that natively supports it is Internet Explorer which is definitely dead.
First, almost all big websites support RSS. Just because there's no giant yellow RSS icon doesn't mean it's not supported, autodiscovery is the main way people subscribe to feeds these days. YouTube supports RSS. Nearly every news site supports it. Every blog. Every podcast. Substack supports it despite launching long after RSS supposedly died.
Even when a website has no RSS support, there's often a way to subscribe anyway using a scraper tool.
There's no reason for it to be supported in browsers when third party clients work great. By this standard email would be dead since browsers don't support it anymore. Most people would rather keep their subscriptions in an online service that can synchronize between devices and has native mobile apps.