Harry and Meghan ‘no longer US golden couple’ as Americans turn backs on them