Since this song is a tribute to all rock groupies, there's the 1970 documentary Groupies
, all about just these such people, including the infamous Cynthia Plaster Caster. Groupies have an oft-misunderstood place in rock history; many of them present the defense that they serve an active role in providing what little nurturing a celebrity can have when they're on the road staying in 200+ hotel rooms per year. Some of them, such as Sid Vicious' FWB Nancy Spungen, become what many would call a surrogate "road wife," traveling from city to city with the band.
And while we're on groupies and the Stones, one of the most famous Stone-groupies is Chris O'Dell, who trysted with both Richards and Jagger amongst many others. And here's a Telegraph article
telling some of her story and announcing her biography. Yes, there she is right in the photo with Richards - she was one of the women Richards was singing about!