I'm sure you won't need that much RAM for your standard-sized maps - they should run fine on commodity hardware. But if it's possible to heavily scale up the size of maps, the larger amounts of addressable memory should prove a great benefit for those wishing to play such gigantic maps. Civ4 very much ran into issues in the memory area on very large maps, rendering its de jure support for larger maps and more cities than Civ3 moot.
I'm glad to hear that 64-bit is official - somehow I missed that news for a whole month! If Civ5 does prove to be an excellent game, I just might have to upgrade to 6GB of RAM and XP 64-bit, perhaps even a better CPU for the most epic maps. The graphics I'm pretty indifferent to - running DX9 on DX10 hardware is more than good enough for me if the strategy element is good.
edit: I doubt there will be a requirement to have a 64-bit system to play really big maps, but if you don't have a 64-bit system and you try to play a Super-Amazingly-Enormous size map, you might well run into Memory Allocation Failures (MAFs) or the like, just as in Civ4. Graphics-settings-wise, you probably would be able to play with the highest settings on a Tiny map with 1.5 GB RAM if you wanted to and had a good enough graphics card.
I really don't see this as a legitimate use of memory. The entire game design (tiles, units, etc.) lends itself extremely well to the reuse of resources. Unless you're talking about allowing games with millions of tiles, you'd probably run into other limitations before 2GB of RAM would hold you back.
The PS3 gets away with 256MB of RAM, after all.