I've heard Debian and Alpine are good lightweight distros

I think most distros will run fine on most hardware though (please correct me if I'm wrong) it's the software you run on it (as in, going with a GNOME desktop environment is going to be much more demanding than xfce for example)