Watch chaos on the bridge, the great TNG doc made by Shatner. The people who actually made the show and were there talk about how hard it was to make and the fan backlash they faced
TNG seasons 1 and 2 were not great compared to seasons 3-7. They had great episodes mixed in, but overall, the acting, production, and stories don't match up to the later seasons, which I wouldn't expect with a new show. Luckily, they didn't have the internet rage mob, so they had time to develop.
Academy is not the show I want for Star Trek. I didn't expect to like. I don't love it, but I have found myself enjoying some of the episodes so far. Yeah i\I don't want the 300lb butch lesbian bridge officer, or Klingons in a Dress, but they are still trying to tell Star Trek stories. Imagine if the old men had access to social media back in 1987 when Gene Roddenberry decided to put Star Fleet officers in skirts....
I understand they are trying to make a show for a younger demographic. They have stated this show is geared towards teens and young adults, so most of us are no longer in that demographic.
I am hopeful the new regime brings in someone like Terry Metalas or Ronald D Moore, to take the reins of the franchise or go back to the Post TNG/DS9/VOY era and bring a new generation of shows. That is one thing I'm thankful for, them jumping 900 years into the future for Academy. At some point, it will all just be considered Kelvin Verse stuff and out of the canon.