YABU to expect a HA/council property to be anything more than an empty shell that is structurally sound and secure. Pretty much everything you have said is cosmetic and something that can be fixed with a little bit of time. It is not going to be perfect and complete on the day you move in and not the council's responsibility.
I moved into a HA property with DD early this year. I have been on the waiting list for 4 years and my private landlord wanted to put the rent up to a level I just couldn't afford as a single parent on a minimum wage job, so it came at the perfect time but it wasn't the perfect condition.
When I viewed it, it smelled musty from being empty a while, there was a pool of water on the kitchen floor from a leaky pipe, there were dirty grey and faded net curtains covering the windows, there were holes in the walls from the previous tenants furniture being removed, there was a cheap and nasty carpet in every room, and the walls were either painted in dingy colours (the bedroom was a brownish purple) or like the hall which had originally been a bright red and then someone had started to cover it with white, but only in random patches and very badly. Despite the condition I took it because it was all cosmetic work that could be fixed/replaced and I needed the property more than I needed a show home.
I got a phone call to view the property one Friday, I viewed the place the following Tuesday and was given the keys on Thursday. It all happened so fast, but fortunately for me it happened within the same week I paid my private rent so I could give a months notice to them, use my savings (meagre though they were) to pay my first months rent on the HA property and have just enough left over in the meantime to buy a couple of large tubs of paint.
It was a pain to be paying for two properties for a month as it meant my budget was really tight but it also meant I had a month to get the basics done in the new place before I moved in so it felt fresher and less daunting to do everything else. Additionally it meant I could pack up my stuff and move it gradually as and when I had chance rather than having to do it all in one go (eg my Xmas decorations were one of the first things I moved into my flat, as they had not long been taken down and packed up before I got the offer, and I knew I wouldnt need them again before the move I could get the boxes put away in the new place and get them out of the way)
I went through and made a list of things that needed doing and put them into a priority list. Cleaning the place was top priority, followed by polyfilling the major holes, then painting everywhere with a pale grey paint just to freshen it up. I am lucky to have lots of family who were happy to pitch in and help with painting so between us it took about a week to paint the entire flat. It would have been doable without the help, but it would have taken weeks to do it between work shifts and I'd have been doing it around boxes as there was no way I'd have got it done before I had to be out of my old property.
I couldn't afford to replace the carpets, so as thin and cheap as they were, once I used the carpet cleaner they weren't in terrible condition so I planned to leave them until I could afford something better. Fortunately my parents have a friend who owns a carpet fitting company and they generously paid for new carpets (though I'm sure he gave them a very good deal) as a gift.
The net curtains were next to go, but I literally went to Wilkos and bought a couple of voile panels for about £5 each and they worked fine to cover the windows (I'm first floor but I didnt want beighbours to be able to look into my flat from their bedrooms). They were only ever meant to be a short term fix, but nearly a year later they are still up as they do their job and my money has been prioritised to other purchases that are more pressing.
There were no white goods in the flat so I bought a cheap under counter fridge second hand from Facebook Marketplace and got by with that, microwave and a kettle for the first couple of weeks until I got my deposit back from my private rental, which I used to buy an oven, fridge freezer and washing machine from a high street store with finance options so I could spread the cost.