I watched all of Enterprise for the first time earlier in the year as my first non Discovery Star Trek. I am now trying to watch TNG and am 17 episodes into season 1 and holy hell does this show suck so far. I have read people saying the first couple of seasons are trash but it is the best Trek series overall but at this point it is a chore to sit through this.
If you're not sure if you can make it, you could always jump ahead to Season 3 and see if you start liking it more. If you don't like Season 3, then the show may just not be for you and you'll avoid wasting a lot of time. If you do like it, though, it might make it easier to go back and watch the rest of Seasons 1 and 2, knowing, yourself, that plodding through them will be worth it... or you could never go back. Don't worry that you'll miss story by doing that because, unlike most shows nowadays (including Discovery and even Enterprise), episodes are mostly self contained and don't necessarily need to be watched in order.
Actually, if you decide to do that, I recommend cherrypicking a few Season 2 episodes to watch first, before heading to Season 3. They are:
Elementary, Dear Data (S2E3)
Measure of a Man (S2E9)
Q Who (S2E16)
Those are the best episodes of Season 2 and, to my recollection, the only ones that set up situations that are revisited in later seasons.
Most of the episodes have predictable and overly simplistic stories, the acting is up and down, and it lacks the immersion factor.
I hate to say this, but that's just how the series is and how nearly all series were before the mid 90s, when it started to become popular to serialize them (maintain one story over a whole season so that each episodes picks up where the last left off). When episodes are self contained, they're going to tend to seem simplistic and predictable and not immersive in comparison to modern series. The Simpsons and Seinfeld have the same issue. We just don't expect anything more with them. With TNG, it helps to learn to appreciate its nature by treating each episode as an individual, short, science fiction story, instead of as a chapter in a long, epic novel as you would with newer series. That said, TNG does get slightly more complex and immersive after the first couple of seasons, but don't expect anything like modern series because that's just not how it was structured.