Turning to Rotherham specifically, I would expect that anyone with the slightest vestige of dignity would, if named in the report or in a relevant position in the council, resign their seat with immediate effect. In staying they are tarnishing not only their party but the very process of local democracy.
A friends mother worked as a senior social worker for many years in a major former industrial northern town left in disgust/apathy 7 or 8 years ago. She repeatedly hints at there being things such as widespread abuse not being followed up (as in R) going on in many other places.