but the majority of the time the people paying for those things aren't the ones using them, which is where people get resentful.
My council does a breakdown of where the money goes. Of that, I 'make use' of rubbish collection, (which is significantly less frequent than it was when I moved in 8 years ago), street lighting, and road maintenance, except the roads by me never seem to get repaired. I suppose I also technically get the benefit of a local councillor but they are useless and don't even live in the area they cover. I also do appreciate that there are less measurable benefits, e.g. the council employing staff who then have money to spend in local services, keeping them open, etc.
But even added together, those services come to maybe 5% max of the council's outgoings - as you say the vast majority goes on education, social care, housing, none of which I use or have ever used. Obviously I understand I'm lucky to not need those service, and if it was a choice between paying my council tax or being in need of them I'd choose paying it every time.
But when people are struggling for every penny I can understand why they get fed up.