That's a good point about trying to build much-needed accommodation, Abhannmor, everything is opposed!
There was a development of timber-framed houses in Dublin that was opposed because they weren't 'proper' houses - I heard one of the protestors say on TV 'They're putting people into garden sheds!'
Then there were houses made from shipping containers - a tried and tested way to produce high quality, well insulated homes quickly and cheaply. Nope, they are 'putting poor people in boxes'.
Then there were 'co-living' apartments, studio apartments augmented by common spaces including gyms, laundries etc. which work well in other cities, especially for younger professional people. These were 'like prisons' [obviously that particular protestor has never seen an actual prison!] and 'the tenements of the future'.
None of these - timber-framed, shipping container, co-living - was going to be the perfect solution for everyone, but each of them, build to a high standard, would have chipped away at the housing crisis. For instance, co-living apartments are favoured by workers in the IT industry, and Ireland is becoming less attractive to that industry because there's nowhere for the workforce to live.
And refugee accommodation - 'we don't want unvetted males living near us' [I think they mean non-Irish unvetted males, the country is full of unvetted males!] but when accommodation is proposed away from highly-populated areas, THAT gets the tricolour-and-petrol-can treatment too.
Somebody once said that we as a people 'hate the disease, but hate the cure more'. Every time a solution is proposed, maybe good, maybe bad, but worth considering, it's blocked, like the social housing projects you mention.