I really don't think the majority of us are 'in favour' of the royalty. I'd say about 10% love them, 20% dislike them to some degree and 70% couldn't give two hoots but think they bring in revenue from gulible tourists. Especially in my generation, they aren't very popular at all (
Kate's family are often straw-manned).
But they won't be gotten rid of, because of history, tradition, tourism and it's just too much of a pain in an arse when we're a stable, traditional country where most of us just can't be arsed making a change. Getting rid of a monarchy would be kind of complicated at the best...