You cant go just on rated speed. An Athlon 64 is around 25-30% faster than a similarly rated XP. That DFI Lanparty 754 is a rockin motherboard. Yeah, the upgrade path may be dead, but honestly if you arent going to use PCI express video cards then it doesnt matter.
There are 2 advantages to buying a socket 939.
1. If you decide later to upgrade to PCI express, you will already have a 939 processor so all you need is the MOBO and the video card. If you go 754, you have to buy the processor too. Of course, who knows what will be out a year from now?
2. Speed wise, there is little to no difference between similar models of the 939 and 754 processors. However, 939 does give you the option of running Dual Channel memory setups (if the MOBO supports it, some dont) where the 754 you cant get it at all. Dual channel can speed up your system.
Dont worry about the dual-core issue. If all you do is game, from what Skuzzy has said, and what I've read on Toms Hardware and AMDReview, its not going to benefit you if your main purpose for your rig is gaming.