You're using a Pentium D, not a Core2. And most LGA775 boards you buy today will NOT work with Pentium D cpus. They may have the same form factor, but they are NOT necessarly compatible. As I recall, it has to be a 945, 955, 965, or 975 chipset, among other things, while the one you linked is a G41.
You would have to do a lot of checking to make sure any motherboard you're buying will actually work with that chip.
And frankly, even though I am still using a Pentium D machine myself, it's not worth investing much money in one. If I needed a new motherboard for mine, personally I'd throw it away and start over.
I think the confusion between Pentium D and Core cpus that resulted from maintaining the LGA775 package is a big reason Intel changes the pinout physical package now when it releases incompatible chipsets.
Oh, and finally, you'd still need to get a video card; you'd just have a lot more choice.