Is there any reason you want a self-hosted service for this rather than making an account with TMDB or TVDB? Trakt fetches all of its metadata from those 2 sites (it prioritizes TMDB).
Not that you shouldn’t self-host an alternative, but you don’t have to.
I have everything containerized (Podman) on my Debian PC and use Diun to check for updates and send notifications to a Discord server that I monitor. I do all of my updates manually so I don’t update unless I have time to troubleshoot; if it breaks I still have the configs and data so I can delete the container and start over.
I also do monthly backups to cold storage (yeah, they should be weekly/biweekly but it’s just personal data that I’m okay with losing). I don’t use a RAID config or BTFS/ZFS like some do, so it’s pretty easy to just set it and forget it. It really depends on what you’re trying to do, how bulletproof it needs to be, and how you like to organize things.
At least a few years. I switched to Linux a year ago and that was a huge consideration for me when choosing Debian over Ubuntu.
Maybe Linux Lite? It’s based on Ubuntu LTS and the default DE is XFCE but you could replace it with LXDE or whatever you want.