I saw Star Wars in the theater when it was just called Star Wars. I couldn't agree with OP more. However I have zero trust that Disney will make more adult oriented shows for the simple reason of merch. What's the merchandising opportunities of Andor? You can't sell lightsaber replicas when there's no lightsabers to replicate.
But you can't have merch if you don't have a popular story and they're jeopardizing the popularity of the whole franchise. I just saw an article talking about the 5 least profitable films from 2024 and 4 of them were from Disney. They make sport of beating dead horses until the world collectively. They've already killed Marvel and Star Wars is bound to be next.