An example of that conflict is in Reading… last year the council decided that as it was (in their view) a footpath, they’d put up no cycling signs on the section between Reading and Caversham bridges (notwithstanding the fact that this effectively broke the national cycle network and pushed people onto a horrible urban dual carriageway).
This seems to have been to appease some batty residents of the riverfront. I’ve seen a horrible woman yell at people down there before (e.g. when I ambled just off the path into a tiny unfenced gravel car park bit to let people past… she came storming out yelling at me about how it was private property. “Yes, stupid that, isn’t it?” didn’t go well with the old goat).
And then Reading council got egg on their face when it turned out to be a British Waterways towpath and therefore legal to cycle and not their jurasdiction. They’ve settled for a couple of chicanes to slow people down… fair enough.