I think a big part of why people aren't as excited for new Star Wars as they used to be is that "new Star Wars" isn't such a unique thing.
It's hard to conceive of now, but try to remember 1997 for a minute. There had been no "new Star Wars" in 20 years. Suddenly Lucas announces (1) he's finally doing the prequels, and (2) he's rereleasing the old films with new technology!
SO MUCH EXCITEMENT!!!
So many possibilities!
Then they came out and....Han DIDN'T shoot first?! WTF?! And man...that Jabba....doesn't really look right, does he?
Then came the prequels and again SO MUCH EXCITEMENT!!! Until...we were all walking out of the theater after watching TPM trying to figure out what the hell just happened.
That process continues over and over -- excitement in anticipation of a new film, followed by a kind of hollow feeling or outright disappointment. I felt it with AOTC when I thought at first "This will be a real course correction" and instead it was just the START of the Clone Wars. And then I just felt...empty when ROTS came out, because it picked up at the END of the Clone Wars and we missed the whole damn thing, and on top of that, the Jedi all die in, like, 30 seconds during a musical montage, and Anakin becomes evil because...he misses his mom?! ARE YOU KIDDING ME?!?!?!?!
Now, personally, I really enjoy the new films. I love TLJ and I like TFA. I've also really loved Rogue One and Solo. But each new film means that the next coming film is not a HOLY S*** THIS IS GOING TO BE ****ING AMAZING big deal. It's just another movie.
I think if you're looking to franchises for that experience...you're barking up the wrong tree. Franchises just keep on rolling and cranking out films. In a way, it's good because a good entry can be treated positively, but a bad entry isn't necessarily the end of the world, since more is coming (assuming you think there've been other good entries).
In that sense, Star Wars as a whole is perhaps less "special" than it used to be because it's less unique. And unlike franchises like the Marvel films, there wasn't a gradual and steady build up, with movies getting better and better. Instead, it's this amazing gold standard right at the start, and a constant chase to recreate that feeling to varying degrees of success.