Same, I needed more after SNW and wasn't quite ready for the way 80's - '00s era Trek was filmed. I actually liked the first two seasons and thought season 3 was okay.
Spoiler alert:
But then we learned about the source of the burn.
And then season 4 happened. And then season 5 happened. It felt like all of these were leaning into my least favorite things about Discovery. By the finale, I was fast forwarding through everything just to get through it.
Watching TNG for the first time now and loving it way more than Disco :)