I think SNW is a good start for someone enterily new to Star Trek. However, I would advise against starting with Lower Decks. Maybe it's just not my cup of tea in general and the only reason I did enjoy LD quite a lot is due to tightly knitted references (i.e. Giant Spock's skeleton, prank calling Armus, and so on). It's basically like how someone here recommended TNG before DS9 because it sets the stage. It's also why I'd recommend skipping SNW's S2E7 (Those old scientists) until you are familiar with LD in general.
May I ask about your favourites of TNG S2? There are some strong standalone episodes. :)
TNG S1 is... odd, to say the least. There are a few single episodes I do like, though. S2 starts off stronger compared to S1 (which is not that difficult) and starting with S3, TNG really takes off. Enjoy the ride!
Of course one can start with LD, but as I said before, it only worked for me because of all the references since the characters, the story and the style of comedy just don't do it for me personally.