does a player have to be god-tiered in order to win the game? also, what, if anything, does god-tier status do for a player, besides conditional immortality, and their group's universe?

No, players don’t have to be god tier to win the game. For example, only Vriska was a godtier when the trolls won their session but Bec Noir stopped them from entering the new universe.