The Order sequel will have to change the formula a lot, and I mean a lot, RaD may as well abandon this game and create a new IP.
Because that worked so well for them this time.
I think the issue is that they bit off way more than they could chew. They're best known for handling a mobile take on an established IP. An IP where they did not need to define new mechanics, story, pacing, themes, setting, etc. Their first attempt at a new IP was on new hardware, in a new generation, in a new genre, on a new platform, and in a whole new ballgame (console vs mobile) where the quality of competition is much higher.
That's an awful lot of challenge to take on at once, especially when being pushed by console warriors and Sony themselves as a hugely important title despite no logic as to why it would be. I blame our focus on exclusives when they honestly mean little - but that's another whole discussion. Their traditional strengths (technical prowess) showed up, but the part they never had experience with, i.e. developing game mechanics and systems for a new title in a new genre, slayed them.
I think it will see a sequel, though. I also think they'll show their capability at improving themselves in a way that will make the sequel look as radical a departure on the established formula as U2 did when compared to the original Uncharted. By that I'm not saying it will be Uncharted 2 levels of awesome, but just that I expect it to be as polished as U2 was when it comes to perfecting the formula. I think a great example would be the Resistance series. It also released with a short campaign, no real love from the playerbase, and some scathing reviews - but it had potential, and they rode that potential to some great sequels. I think RAD will have a chance to prove what they're capable of in this world again.