I have no idea how people can use LLM-generated code. In my experience they're absolutely terrible. However it can be good for giving some insights time to time.
I have a netbook from 2011 and I use it as Pi-hole and Jellyfin. You can add a backup system as well. Just go with headless Debian, you'll need every bit of CPU. Then you can just ssh into it and do everything like that.
This is Aurora SPARC, not Aurora. Currently Aurora doesn't exist on Distrowatch. It's Bazzite's sister. You can check how active it is from Github. Latest stable release, 5 days ago.
Everything will work out of the box, you won't get weird errors like Ubuntu gives, you can go back easily from GRUB if something goes wrong. Being an atomic distro may feel different but I'm sure you won't mind.