Thank you!
I did a quick search and found that redirecting users to a non-existing page might not be good for SEO. So I decided to use the following rule in my redirects.yaml:
301:
^\/tag\/([a-z0-9-]+)\/rss\/$: /tag/$1/
It will redirect
from your-ghost.site/tag/faq/rss/
to your-ghost.site/tag/faq/
from your-ghost.site/tag/billing-and-charges/rss/
to your-ghost.site/tag/billing-and-charges/ and so on.
P.S. Some people say redirecting to a home page is considered a soft 404.