Yeah, it’s literally about an intoxicating, exotic woman with a penchant for the high life and partying (and apparently drugging and robbing her suitors) but the metaphor, as you note, is one of drugs and the crazy rock star life. But pretty much any song about a relationship (particularly an unhealthy whirlwind one) can be interpreted as being about drugs.