The philandering 55-year-old has 'gone from being rock god to scumbag overnight, it's changed the dynamic and he hates it'