A veteran councillor says the public are entitled to know what led to a blunder causing a major sewage spill onto a beach and requiring repair work costing hundreds of thousands of pounds.