I don't think the sales are terrible for US alone and for it to be a platform exclusive. All the games above it despite Majoras Mask are multiplatform. The game below it sold 290,000 copied including digital, so not sure where that puts the Order except that it is somewhere above that.
Can't imagine that happening now. It sold somewhere between 300k and 500k retail in its launch month while receiving an absolute beating in terms of reviews and word of mouth. Unless I'm remembering incorrectly, people were also saying that sales fell off a cliff on it pretty fast. I wouldn't be surprised if it does somewhere around a million sales lifetime.
I had some fun with it but the flaws were too numerous and glaring for the game to become a big hit. Alongside the terrible PR, game length, etc., Sony is lucky it was a complete and total flop.