You’re spot on! There’s no rescuing it though, it’s too late. The only scenario I can think of that would salvage it would be if they separated this part of Disney canon out into its own sphere and went extremely wacky with it. Like basically turn it into a convoluted over the top anime series full of the most absurd retcons and “lore” details.
This is why I actually liked Rise of Skywalker, it started to do that. Very fast paced, cracked out editing, stupid sith daggers, possessed C3PO, goofy unnecessary characters, new force powers everywhere, meme dialogue, Palpatine returning and shooting bass boosted lightning into the sky, etc. Setting all the other problems with The Last Jedi aside, Rise of Skywalker was so much more fun. Just take that to its logical conclusion instead of trying to do a very serious important story about the rise of fascism or whatever. (not referring to Andor)
Doing a high quality Andor-level series would just be wasted on something that doesn’t deserve that treatment.
If we were starting over from scratch, that’s another story.