For Crime sakes. Don't over think it. The title of the series first marriage. Kinda sort of implies. They are going to split, but possibly end up back together at some point anyway. So don't over think something that hasn't actually been written yet.

Besides one of the big plot points in Young Sheldon. Was supposed to be George SR. Affair instead it was just Sheldon being clueless to what was going on.

Yes there will be a split, but the title first marriage might be an indication. Eventually they end up back together. So don't over think a plot that as still yet to be written.

The First Marriage in the title. Also leaves the door open just a crack. They remary and try again. So don't over think it. Wait and see what happens.

Young Sheldon used a little creative writing to Retcon whatever assumed was an affair by Grorge. Only to have it turn it Sheldon walked in on his parents role playing.

As smart as Sheldon supposedly was, what was actually going on went over his head. So my point here don't over think it. Wait and see what happens. There will probably be a few more twist, and turns before the series ends. Unless CBS decides to cancel the show with no notice.

At this point we know there will at least be a second season.

Death has not been a forever thing in Star Trek since the 60's. Even then you had to be a back ground character in a red shirt on Kirks Enterprise.

A little creative writing, and the Character could easily return in Future trek project. Don't overthink it!

Don't count on it. There is not Much chatter around a Prodigy season 3.

There isn't much need for the character in live action. So unless there is a surprise coming up in the final episode of Lower Decks like the return of a version of T PoL in the most recent episode of Lower Decks. I would not hold your breath on a return of Kes, any time soon if ever.