Well lets look at the situation. 1st Picard ended with a great season. If they do a spin off great yet that depends its a good crew and the TNG characters could guest now and them as a certain Ensign gets a visit from his Admiral Mom and Dad .
Prodigy sadly I feel it was a cross between a Young Voyager crew and an animated Academy idea. I am sorry kids would rather choose something else. And Discovery suppose to end and they held it back until next year IF they doing a new series then it was suggested that Disco would make way fro Section 31 yet its more likely the Academy series .
I agree Strange New Worlds is now the flagship show and Lower decks will be all we have the rest of the year unlike 2022 when we had the year of trek wow was they fun 5 series in on year. that probably will not happen again. I do think they be a new series out next year what it is is up to Paramount
I think spinning off Picard is the best option because we can get a follow up to DS9 era Trek