It's a lot more complex than that; the genre is super-niche, the playstyle is very deliberate, and horror games are rapidly approaching fatigue crescendo levels amongst general consumers. New consoles saturation also isn't where'd you'd need to be for a title like this to get "amazing" numbers. Frankly I would have picked a window later into the year for closer Q4 vectoring, but SEGA's marketing approach hasn't made sense to me in years.
I think people should happy with what they got considering whom is managing the license, and while as a hard canoneer I still have problems with the title's presentation and mechanics, at the end of the day it's a solid niche title that does what it intended to do.
CA proved they can handle AAA without too much logistical leveraging concerns, and SEGA actually managed and produced a licensed game that isn't a complete clusterf**k.