People get confused about this a lot, but they’re thinking about it the wrong way.
You don’t greenlight a sequel based on whether the first game was profitable. You greenlight it based on whether you think the sequel will be profitable.
You also don’t aim for breaking even or mild profits. If you’re putting up tens or even hundreds of millions in an investment where you could lose it all, you want a major return to make the risk worthwhile. Otherwise, you just loan out the money or put it in the stock market and get a much larger and safer return.
Games continually cost more as time goes on, and The Order had a very poor reception, so unless Sony thought Ready At Dawn would deliver a vastly better game that could sell notably more, they wouldn’t have greenlit a sequel.