More than three quarters of Canadians feel their country should not foot the security bill for the Duke and Duchess of Sussex, a new survey suggests.