honestly most distros will be fine. what matters more is your desktop environment. pick something light where Bells and whistles can be turned off. i used fvwm for many years on a lower spec system. now I use kde/plasma on wayland.
I’ve used arch and Debian on low spec systems. both were fine. slightly prefer arch cause it’s more up to date
can u boot Linux of a USB? some USB drives give 1000mbps read so should be nice and snappy for a root fs