In recent years, overseas box office has become very important to the studios. There are many franchises that do good but not great domestically, but turn bigger numbers overseas to justify remaking them. Franchises can't bomb domestically, but if the overseas numbers are healthy, studios will continue the series and make sequels.
Obviously what is considered a flop depends on many factors and risk management is taken into account. Another thing to consider is that these quoted production/budget numbers often do not account for the marketing which is very expensive. Detective Pikachu is an unusual take from one of the most profitable multi-media franchises so I think it will be fine. It's doing well internationally since it has a wide global following. The studio may or may not try again, but the Pokeman franchise won't be hurt by it. Men in Black is too early to tell, but it's not looking good. The X-Men movies have being downward trending with every subsequent movie and this franchise has been turning stale. The last movie did do ok overseas. Deadline reported the studio will lose $100-$120 million on Dark Phoenix. If Fox had kept the franchise, it's questionable what they would have done with it next.