The only reason it didn't chart is because the bundled copies are not counted in the sales chart. According to what someone else posted here, it would be in the top 10 with the bundled copies. I never saw an ad for it on youtube, and I don't have television service, so I don't know if I would have seen ads there. Maybe Microsoft thought it would be a blockbuster, but from reading comments online whenever game info was released, I'm not suprised it wasn't a smash hit. To me, it didn't seem like a game that would be, and the general feedback from people seemed to confirm that.
I like the game. I think it's good. It's not the best game I've ever played, but I think it's fun and solid. That said, it's not for everyone. It's a very niche style of gameplay.
Not to mention, it's an exclusive on the next-gen console with the fewest sales. If the game was multiplatform I'd think the sales would have a significant boost. Probably a lot of Insomniac fans with PS4.