Sideshow Cassandra was one of the old sideshows. They used to appear on the Krusty the clown show and he was one of the sad sideshows. He retired and never appeared again.
Sideshow Cassandra's name suggests they may be a bearded lady act but no further reference was made to this.