One can "do the right thing" all ther life and still fall on hard times. Life's like that.
I suspect the drunk drug addicts are seen as a problem which the council has to solve. Whereas homeless non-problematic individuals are not uncommon, an issue that may never be fully solved (especially if governments make no attempt to reduce rather than increase the population) and so those in that group can join the queue.
Councils do make priorities and sometimes this seems reasonable, for some folk are more vulnerable than others, but their present system does seem to fail those who don't fit into a special priority group. I don't have personal experience to speak with authority but as a citizen it does seem we get neglected cases arise.
I think the issue where anyone who has done the right thing gets nothing is extending the subject area though. For sure there is little enough being offered for those who pay in to the public kitties all their life, but I think that a different thread.