I own my own home, we needed the drains, for our house and 2 next door neighbours, repaired by relining (Off grid for sewerage so not a standard set up).
First drain survey company were cowboys. Then it took months to find another survey company, who were fantastic (contracted to the local authority), turned up when they said, clean, tidy, polite and professional. They recommened a drain repair company, also contracted by local authority and MOD etc, to reline the drains.
First dates planned, no show, next dates they turned up a day late, this was back in March.
They didn't do a final survey (as planned) so we didn't pay, fortunate really as one section wasn't done properly, collapased and blocked the drains causing it to all back up and flood NDN shed, we bodged a temporary solution which meant daily inspections by DH and NDN. We had 3 weeks when we couldn't flush toilet roll.
Eventually they turned up again, didn't communicate with anyone, DH and NDN WFH so no reason not do, still didn't fix it correctly, still didn't do a final survey etc etc
Many phone calls, emails, late invoice notices and 5 months later theyhad finally sorted it out properly completed a final survey, sent that survey to us and resent the invoice and we paid it today.
So my point is OP, I don't think your problems have anything to do with be a Council tenant, and are unfortunatly the experience of many resisdence, be they tenants or owner occupiers. How we turn around the shody attitudes and standards of a good number of tradesmen and companies I don't know.