Debian can still work, but you’d have better chances with legacy LXDE, or starting with no DE and installing IceWM.
Q4OS Trinity, antiX, and Damn Small Linux are all Debian derivatives known for being able to run on very old systems, and they’re among the most lightweight distros I know that are still functional for most purposes.