The story
From fair-weather + fan, drawing an analogy between good weather and trouble-free times.
Etymology from Wiktionary, CC BY-SA 4.0.
fair-weather fan
Today it means: A fan who only pays attention to their favorite team when they are performing well. Full definition →