Rock’s greatest showman opened his new tour with a blazing set excoriating ‘an unfit president’. But was Manchester the right place for it?