红 here means 'popular / famous' (as in
走红 'to become popular' or
网红 'influencer'). The phrase always implies the popularity has since faded — almost never used about someone currently famous. The implicit follow-up is 'but now is forgotten / out of fashion'.
