In a video shown to the jury, the former protection officer said the Prince was widely regarded as one of the 'least popular royals ' because he was 'rude' to staff members