There was only one way the Pia Zadora story could end: Charlie Sheen-level ridicule or Cher-like triumph. So which was it?