The original Star Wars triology was a love letter to old time movie serials from the 1930s and 40s like Flash Gordon and Buck Rogers. For those who might be unfamiliar with a serial, these were short films shown before the main feature and each episode would start with a recap of the last episode and most often ended on a cliffhanger. These serials had uncomplicated plots, good guys & bad guys, and were something kids could enjoy.
I think positive and heroic things are built into the DNA of Star Wars. There's certainly room for tragedy, The Empire Strikes Back is a great movie, but with The Acolyte, a story where I can't easily point to the good guy, I think they've lost the thread. I may be the odd man out here, but I'm not looking for a lot of nuance in my stories about space wizards, smugglers, and and princesses. Maybe that's why The Acolyte failed to resonate with audiences.