Brisbane’s St John’s Cathedral Dean Peter Catt retires after fallout over Stan’s OnlyFans reality show