I avoided watching this for 20 (!) years, because the reviews were ambivalent. But it's really fun. It's not awesome, like the Kirk/Spock series, but it's also (thus far) not excessively moralizing like TNG.
This is the only Star Trek (for me) that captures the wonder of the original series. The writing isn't great, but that was never a thing with Star Trek. They're also a bit kinetic, say, with discovering new Warp-Civilizations.
I also really appreciate that the crew is basically white, except for one black guy that's not blackity-black.
Even the chicks are fine. The writing for the Asian chick is a bit insipid, but it accurately reflects the chick version of the 'hero's journey'.
Unfortunately, they've introduced Time Travel, so I guess a few of the episodes are going to be tedious.
The first season for really bad for way too many shoutouts to future Star Trek stuff. They toned it down later on though and made it seem less forced which was better.
All Treks except DS9 started very shaky imo as you pointed out but Enterprise was essentially riding off the coattails of DS9 so people at the time had less patience for bad starts. Compared to TOS, the TNG+DS9 era really advanced the technology in the Trek universe and the high-tech was fun. Enterprise went backwards where there was less tech which was not exciting for Science Fiction viewers. Then combined with the opening theme which in itself seemed the very opposite of progressive (it sounds like some sort of Christian Rock song... Faith to believe, lmao) it just seemed to be all the wrong messaging.