First of all, I expect that the retail version of Lightroom will be far faster than the clunky Windows beta I've tried. Is Adobe planning on releasing a version of LR capable of supporting 64-bit, dual core systems? I love the sleek, Lightroom interface much more than Photoshop (although I like photoshop's capablities the layout is awful, and reminds me of a more cluttered version of Windows Paint), but I can't help but feel that its sliding menus and smoothness will cost extra memory. Support for 64-bit dual cores would improve the situation in my opinion.
LR already has partial support for multi-processor systems.
A dual-core CPU is nothing special in this regard; to the application, it looks like two processors for the purposes of parallel computing.
I'm not sure what you mean by "supporting 64-bit", though.