I've long been a core audience type for Star Wars, and frankly Andor had no appeal to me at all. This claim that it would appeal to long term fans of the franchise who have been turned off by Disney, as I have with a lot of their recent offerings, doesn't hold water, because Andor suffers from the same problem that almost all of current Star Wars, including all the Sequel movies, suffers from: A fundamental misunderstanding of the core of Star Wars.
Star Wars, at it's core, is a Heroic Epic pitting larger than life Good against larger than life Evil. Say what you will about the Prequels, but they still understood this core aspect of Star Wars. Star Wars is not a setting about shades of gray, no matter how much people pretend or want it to be. It is an explicitly Black and White setting founded in a form of Absolutist Morality where the Means are just as, if not more, important than the Ends.
This is why the Force and the lore around it is so important to Star Wars, and any Star Wars property that brushes aside the Force ends up being hollow.
But Star War's core morality is at odds with the preferred morality of the modern world. Star Wars, at it's core, embraces a Stoic / Christian / Buddhist hybrid philosophy of enlightenment, where denial of personal wants and desires in pursuit of higher ideals is seen as a Good Thing, while indulging in self pleasure and hedonism is seen as explicitly a Bad Thing. That holds up hard work and self improvement as good goals, while denying that people are just innately good at things because of who they are. It sees the Means as just as, if not more important, than the Ends, and in fact holds that the Means by which you go about things will actually end up impacting your Ends even if you did not want it to. There is no "using evil powers for good" within the core of Star Wars, as as you use evil powers to pursue your goals they will invariably twist you until you destroy your own original goal (see, for instance, the entire Fall of Anakin).