I think personally the direction Trek is going in is going to massively backfire. The problem is these new shows are not good nor interesting and have no hook. They retain nothing really what makes Trek an unique sci-fi franchise and are clearly just trying to be Mass Effect mashed with every trope from Prestige television with a Trek skin and frankly are just frankly atrociously written and paced and outside of TrekBBS and /r/StarTrek I find almost nobody I know who likes these shows or even watches them.
You can tell they're going for the Star Wars/Mass Effect audience but all the Star Wars/ME friends of mine dropped Discovery after like 3 episodes into S2 and all of them dropped Picard after 2 episodes. The fact is, there are far better sci-fi shows out there on much better and larger streaming platforms than what we are getting out the Trek franchise at the moment.
What these new shows have done though, is put Star Trek sort of back into popular consciousness, so what I'm seeing among my younger Gen Y and Zoomer friends is people rediscovering TNG, DS9, ENT and Voy and loving them. Every time I'm in the Pub and TV show talk comes up and Star Trek comes up which is suprisingly often, people are watching DS9, ENT or TNG again or for the first time. What is also more interesting to me is a lot of Gen Y/Zoomer women are starting to bring up they're watching TNG or Voyager etc.
People here and on /r/StarTrek that everyone wants some lame dark mystery box soap opera in space, but honestly in this time where the real world sucks, politics is awful and things are stressful, I think people legitimately just connect with the Utopian, relaxed, COMFY shows that B&B Trek are. The reason I put comfy in capitals is because that is what I hear repeatedly from people IRL who are now watching TNG, it's just a comfy show.