Will Star Guardian Game Mode come back?

All I remember was how frustrating it was to move along the path in that small circle.

Yes. It's a seasonal event, like Pool Party or Vs or Urf. Riot will release five more SG skins and hopefully a new Invasion mode, but at least another set of skins this september.