i dont think the franchise will run out of new stories. its about infanite possibilities and hope, there will always be room for more of that. i do think a lot of trek fans miss that not all trek shows are aimed at all of trek fans. tng and ds9 had wildy different vibes. theres peace between those fandoms now, mostely, but people thought ds9 ruined trek. people though voyager and discovery ruined it. personally i think one of the coolest things about trek is that it will run different shows with their own tone. discovery made a lot of people feel connected to trek in a way older trek never could. new worlds i still havent started because episodic isnt my favorite. and picard was hard for me to finish because the fan service was from tng which is my least favorite trek.
give me ds9, voyager and discover on repeat. someone else in here is gonna be a dire hard enterprise fan. its a universe built on exploring differences, makes sence it'll do that in different ways for different audiances too right? if you're not feeling the current in production trek its a great chance to binge some old trek.

absolutely. if the show had kept Pulaski and developed the character she could have become a beloved member of the main cast. imagine the stories we could have gotten about her and data developing a close friendship over years. her routinely calling picard out like everyone did to him in picard s3. but at that time in tng her personality was as present as picard and that just wasnt allowed.
everyone loves faciest space lizard man because we got years of him and dr twink boyfriend being awesome on screen. his character had room to devlop.