The 8-core makes sense today if you are using software today that can take advantage of the extra cores. Otherwise you are paying a premium today for something that is going to be outdated soon and won't offer you the performance for which you paid until it's obsolete. Put that $2,000 into an Ally Bank 12-month CD. By the time software catches up with Snow Leopard, you will have an additional $2,050 to spend on a newer, better performing Mac Pro. But that's just my opinion.
A lot of the system internals in Snow Leopard can use all 8 cores. It's not a must have reason for the 8 cores, but it does make for a bit smoother of an experience.