Harry and Meghan warned US is ‘absolutely sick of them’ as popularity plummets