The will of the people is not known on this matter

The Guardian, a respected left wing publication, conducted a survey.
I linked to their report of it.

"Pro-royal feeling is spread remarkably equally among the social classes, and across the regions of England and Wales. It is less marked in Scotland – where 36% say the country would be better off without the Windsors – but even there a solid 50% feel the opposite way. Support is stronger among the older, and especially among Conservative voters, in whose ranks it reaches 82%. But across every age group and among Labour and Liberal Democrat supporters alike, the monarchy is enjoying solid support."