The point in which someone was once famous or
well-known, has ceased being relevant in pop
culture - leaving them only to be occasionally referenced to in obscure references or jokes, making them
fodder for the "where are they now?" file
This usually follows subsequently after that famous person's final attempt at retaining relevance in the cultural spotlight fails miserably, also known as jumping the shark. This is especially true for one hit wonders.
The quintessential example of this would be Milli Vanilli. Once successful in the early 90's, it was later revealed that the
music produced was not their own. After this revelation, the public ceased caring about the group; and they have opted to disappear from the public eye out of emasculated embarassment, thus their
fade into obscurity.
Other examples are Spuds Mackenzie, Fred Durst, Vanilla
Ice.