My wife grew up watching Star Trek with her parents and is a life-long trekie. She absolutely loves Lower Decks. She was also jazzed when I told her I heard a rumor that the Orville was getting a 4th season. She's said that's her 5th favorite Star Trek show and it's not even Star Trek. *LOL*
We've got them ranked TOS >TNG >Lower Decks > Enterprise > Orville > DS9 > pretty much everything else in a bunch of not for us. I say these are "our" rankings but I've already told you who wears the Phaser in our household. I get the bowcaster and thermal detonators.
I love The Orville, I think it's the most Star Trek thing that's been on television since Voyager (in the Roddenberry sense of "Star Trek" as an optimistic vision of the future). However, sadly I'm pretty sure it's done. I would be happy to be wrong, but it looks like several of the main cast want out, and Hulu isn't really interested in doing the negotiations to keep them on board.
As for the order... TNG is my favorite. It was what I grew up on, and it's absolutely a comfort food show. DS9 is a very close second, though. I think objectively you could make the case that it's the best Trek ever, but TNG still edges it for sentimental reasons. Voyager is a tier below, it had some weaker characters in the ensemble but still had way more good than bad. It's hard to rank Lower Decks and Orville for me, I guess they're too new. Below those would be Enterprise and TOS. Enterprise only had one interesting character in the whole cast (T'pol), the rest were forgettable. And TOS had a lot of great ideas, strong characters, and was obviously foundational to Trek, but I have to admit it hasn't aged well. For some people the campiness and cheesiness is part of the charm, but it's not as fun for me to watch because of that.
Discovery I don't even count. I watched a few episodes and stopped, it really didn't feel like Star Trek to me. It felt more like Battlestar Galactica, which was a good show, but it was not Star Trek. I've heard some good things about SNW but Disco kind of killed modern Trek for me.