A member a while back was using an older Inspiron 1502. He over-all had everything working just fine except One Trouble: Graphics Drivers.
Other options include using Zorin 12.4 Lite.
In my opinion, You would get more from Zorin at a reasonable performance. However, if you want to go for Light and Fast, Antix may be what you want. It is a very simple desktop and OS and it does not come with a lot of frills. This also means, Antix OS may struggle on heavier applications you may want to run on it. And you would be more likely to need to fill more dependencies to install packages.
As Aravisian said you have nothing to lose.
I have a HP 6910p that is a similar vintage in the fossil records, 2007 ish.
Its a 2x2x2, 2 cores (Dual core or core 2 duo) running at 2Ghz with 2GB RAM.
Had Zorin Lite on it for a time now got Linux Mint Mate both run fine for general tasks, email, Youtube, word processor etc. Also got Windows 10 on it but seems a bit sluggish there.