No, it will not work that much better.
The problem is not the amount of video ram, it's that the Macbook's shared graphics processor is totally unoptimized for 3D.
Barefeats did a comparison
here. Some games showed a marginal improvement, but overall it is still very subpar.
You still need a MBP to play newer games with a decent frame rate.