A lot of it will come down to what you're running for a desktop environment and software. I've got an old laptop with a duel core 2Ghz (x86_64) processor and 2G of ram, and running Debian with XFCE it can do basic web browsing, video playing/streaming up to ~720p, game emulators, etc with the same snappiness as a normal computer.
Ubuntu is a bit bulkier than Debian and some other Debian derivatives, so if you go with Ubuntu you'd probably make sure to go with a more lightweight 'flavor' with a non-gnome desktop and remove anything you don't need.
Alpine and Puppy Linux are two other super lightweight distros that also might be worth checking out (albeit Alpine being a little more advanced and Puppy Linux being a bit limited).
Very nice. I like how you went about telling the user how to make a decision and provided and their various options rather than just spitting out a list of distros you like without telling the user why you did so. One thing I would bring up though, depending on whether you want it to be closer to a one stop shop or a springboard to further research, would be that for a new user touching a few pros/cons of the various aspects you mentioned (e.g. stable vs rolling releases) to maybe point them towards what would be a good fit for them. But that's more so depending on what your philosophy is on the "what's good" vs "how to find what's good" slider of things.