This is not how it works today, AAA video games are not products made to simple costs vs profits as they used to be. They are made to push up the stock prices, made to increase investor confidence in the studio going forward. Video games are financial instruments to impress investors and little more.
Stellar Blade was a huge success, because it showed the world the company could make a AAA game and it sell a million copies. It did what it was made to do, massive success.
Dragon Age is a total failure even though it sold the same or more than SB, because it sold vastly under expectations. It did not do what it was made to do.
SE has the same problem, they are continually under-performing and losing investor confidence, and since all the CEO cares about is the share price that's not good. Even their biggest release this year (ff7r) massively under-performed, even compared to Dragon Age V.