All the main good guys survive and win.
One of the good guys gets turned into a White Walker BUT manages to retain some vestiges of their old personality after a massive internal struggle between good and evil, and then kills the Night King or enables him to be killed.
Both would be a huge cliche and not in the spirit of the show, imo.