Well it works best if the game is actually good.

A game that does seasons very well is Deep Rock Galactic. Each season comes with fresh new content. Old seasons can be revisited if you missed them, so no stress. The new additions to the game are permanent, which adds great variety to the missions. Progress follows between seasons, so no need to create new characters from scratch.

Most importantly: the game is really good as well.