I think part of the reason Star Wars has done so much better with its prequels than Star Trek generally does is because they choose moments in the established history people are interested in and explore them. Bad Batch shows the switch over from Republic to Empire, Andor and Rebels are about the birth of the Rebel Alliance, Clone Wars tells the story of the Clone Wars.
Star Trek, on the other hand, isn't interested in telling the story of something we know about. Enterprise was getting there at the end, right before it got cancelled, but generally they're only set in the past because they want to use the most iconic characters.
Though Star Trek is better equipped to tell sequels, as it's all about putting a team in a space ship and seeing what's out there. It's not stuck in cycles of evil empires and rebellion, it doesn't have a mythic Skywalker Saga at its core, they can just say "It's 2415, The USS Spaceship is being sent out to see what's in the Beta Quadrant on a joint mission with the Romulan Free State" or whatever, and go have space fun with occasional political drama that pushes the story of the Alpha Quadrant races forward.