I guess it depends. You're definitely not going to NEED that sort of core count unless you're a render farm or running complex calculations for NASA or something.
On the other hand, if you design games for those cores from the start you could get some stunning performance gains. Imagine splitting physics calcs, AI routines, particle effects etc across multiple cores. You'd be able to increase the amount of stuff happening on-screen without compromising graphic quality or frame rate. It has incredible potential.