I’m not claiming that you cannot tell an effective story when you know the fates of the characters, just that Rogue One was particularly ineffective. Usually to make those plots compelling you need to have interesting well written characters with motivations you can understand and care about. The most compelling character Rogue One has is a funny robot.