It's easy to say in hindsight that the game wouldn't become a success.
But at the time everybody thought it would sell fairly well. 1-1.5 million was probably a reasonable target lifetime (some copies at discount) and upside was +2 million.
Probably it cost $20 million. All AAA games cost at least $20 million. That requires 1 million copies at full price to break even.