The flop is wiping out an entire plan for a new movie series, as the studio becomes the latest superhero studio in need of a pivot.