The goal of subsidized housing is to make housing more affordable for some group of people, subletting likely has the same effect so the money subsidizing the building is still going to the same thing.
Now, it might be that I shouldn't have given you the $50, or that we should have discussed giving you a business loan instead - those things are fine. There's nothing fundamentally bad about running a lemonade stand. You simply can't run a lemonade stand with charity earmarked for not-lemonade-stands.
Renting on Airbnb has the effect of subsidizing this one person's housing, not of subsidizing the community's housing.
If the goal is to use Airbnb to increase social housing opportunities, the council should do it directly, so any excess profit can be reinvested in new housing for more than just one person.
The government does not want the limited number of subsidised spaces to go to people who are happy to move away from the area and receive the market value of renting the place. This effectively results in the government granting them an income, and the social problems continuing, where a space would otherwise have been available for somebody else.
The whole idea of council housing is that the state provides you housing because you can't provide your own. If they're renting out theirs, where are they living? They apparently don't actually have a need, else they'd be living in it. So they're profiteering off housing that someone in need is still on the waiting list for.
(I'd be tempted to agree with you if they were renting out their couch; the screenshot shows "Entire home/flat; 3 guests")
Person A needs money because rent is high, person B needs housing because housing is scarce, A rents B their couch and everyone is happy.
Obviously that’s a little different than just sticking the whole thing on Airbnb, but it looks to me like it’s legally considered the same when it really shouldn’t be.