Like his sister Missy, Georgie’s future is already set in stone by the events of The Big Bang Theory. After Young Sheldon’s George Sr dies, Georgie ends up trying to support his mother and his younger siblings, eventually overworking and burning himself out.
Before forgiving Sheldon, Georgie sacrifices his independence, and presumably his relationship with his first wife, to support Mary, Sheldon, and Missy. There is a good chance that the ex-wife mentioned in is Mandy, his current girlfriend who is pregnant with their child in season 6. Georgie’s grief over could be the conduit that leads the new parents to break up, but this would be a brutally depressing turn of events for the series.
Georgie and Mandy are unfortunately doomed to break up because Georgie is divorced by the time he is seen in The Big Bang Theory. This could potentially mean that they get married and managed to last a few years after the end of Young Sheldon but before the events of The Big Bang Theory, but it seems more likely that the volatile couple would break up sooner than later.
The worst way for season 6 to handle the death of George Sr would be for the show to depict Georgie and Mandy continuing their relationship, having a child together, getting married, and then breaking up because of Georgie’s inability to provide for two families after his father’s death.