It would be ideal to have a "private" RSS feed for paid sub, I agree.

For now I use feedbin, which lets you subscribe to newsletters with a custom feedbin email. Other readers also do this.

The downside is that your substack login address has to be a feedbin address.