I’ve been running FreshRSS for several years now without any problems, but mine is running on a dedicated home server running other services too.

Your experience will depend on your RSS client. As others already mentioned, you will want to configure your client to only pull manually (usually on open only), otherwise it will keep throwing errors at you.

I am going to second the recommendation to get your hands on a cheap Raspberry Pi (you can easily run it on a Zero 2 W) with an 8GB microSD. You can then get a cheap US$2/year domain and use Cloudflare Tunnel to access it from anywhere without having to open ports or expose your whole network to the internet.

The full setup should be around $50 including the Pi, case, microSD, cable, power adapter, and cheap domain in NameCheap or similar.