While Rogue One and Andor can be tough viewing and are certainly different from our usual Star Wars style storytelling . . . this is what I love about both shows. They don't pull many punches.
I feel this would be a much more depressing show if we didn't already know how it all ends. In universe, this is sort of the low-point of the rebellion. While more people and resources are being invested in the cause, it feels the Empire is consolidating its power at a much faster rate.
I expect the show to end on a very somber note.