Rolandfan,
Of course talent matters, one of the most important things are the samples, bigger doesn't necessarily mean better.
But of course, If you take two equally talented sound designers, and you let them both sample a Steinway piano, and one has to make a 64 mb piano sound and the other has to limit theirs to 8 mb, the 64 mb will obviously sound better.
So to answer your final question, I think it is a little of both.
A 1 mb piano sound won't sound impressive, but that doesn't mean a 1 Gb piano will.
Hope this helps,
Greetz
,
Marcel