The Duke of Sussex remains unpopular overall, but new YouGov figures show his favourability has edged upwards after years of decline.