I actually agree with him. I don't think GTA will sell much more than 500k in the US. But so what? If the game can sell anywhere close to a million worldwide it'd be a financial succes for Take 2.
Also, I'm pretty sure the game will see minimal advertizing, so again: 500k in the US would not be bad at all.