The video card is all but irrelevant for Civ4; it runs fine on high on a midrange 2002 card graphics-wise, even on high settings (I've done this myself). And that isn't a bad card at all - it's a performance card from the latest iteration of cards. Some people are just addicted to always having the latest, greatest, and most expensive
.
Not that a better video card wouldn't help in other games, but for Civ alone it would be a waste of money to get a better one.
Memory tends to be the issue with Civ4 - it needs lots of it. A 124x68 map is huge, so a 192x120 is about four times huge in terms of # of tiles. A huge map normally takes about 500 MB (I think) of memory around 1850, so this one would require about 2 GB. Which could be a problem, because by default 32-bit programs (including Civ) are limited to 2 GB RAM, and even if you allow them 3 GB (a switch within Windows), most 32-bit programs cannot take advantage of more than 2 GB, even if you have more installed or have a 64-bit OS and/or processor.
So basically that map size is likely approaching the architectural limits of map sizes due to CivIV's memory usage. My estimates are probably a bit off, so you may come in a hare lower than 2 GB and be just fine, or CivIV may actually be able to take advantage of 3 GB with the Windows switch. But the only way to find out is to test it, and you won't find out for a few millenia until memory usage hits max. Even then it might not crash - just get really slow once memory usage hits 2 GB if it switches to pagefile instead.
The 4 GB will help in that it allows 2 GB for the OS and all other stuff (assuming 64-bit OS, otherwise 1.2 GB), but all the RAM in the world wouldn't get you around the software limitations.
As to the processor, it should be fine. CivIV can only take advantage of one core, so from a Civ perspective it was a very good idea to get a fast dual-core rather than a quad-core. I've never actually tried this huge of a map, but a regular Huge one ran 30-second turns on my old Pentium 4 2.66 GHz, so with twice the power you should be looking at two or three minutes max even if the increase in turn time is more than linear - provided, of course, you don't hit memory problems. Those'll throw in-between-turn times up by a factor of twenty once they get bad, so you'll know if you run into them.