Exclusive: Frontline staff warn demand for dwindling housing stock is growing as they are pushed ‘closer to the brink’ themselves