Despite how much publishers love the idea of franchises, it can sometimes take a lot to justify continuation. Because while the likes of FIFA and Battlefield don't have to worry about their future if they release a dud or two, most games are forced to hit ridiculously high bars both commercially and critically if they want to guarantee a sequel.
In fact, history is riddled with franchises that have been stopped dead in their tracks because of one disastrous misstep. In 2017, Mass Effect was thrown to the dogs because Andromeda didn't do as well as EA would have liked - and that game was far from a total disaster both in terms of sales and critical response.
With that said, while it can be disappointing when franchises are canned because of a bad game, it's even worse when they're put down despite the developers releasing a great game. Publishers demand such a huge margin of success for their titles that it means anything that doesn't rake in hundreds of millions of dollars is considered a total failure.
It isn't exactly fair, and these great titles didn't deserve to be the death knell of their respective works.