The problem with the Acolyte is, sure maybe it has more viewership than real housewives. But Disney isn't going to sell anything because of it. And that's the bread and butter of a star wars anything. Can you sell toys, collectables, Halloween costumes, lunch boxes, clothes, toothbrushes... I didn't see general mills making a power of many marshmallow crunch. That's the power of really good star wars, you can go crazy with licensing.
The Acolyte wasn't good. And it did next to nothing for merch. Now granted neither did Andor. But that was considered great by most so they are willing to give it a final season. The Acolyte wasn't really even considered ok by most peoples standards.