Yes, I think those people want to see homelessness end. Why else would you want a career in that field?
Climate scientists also want action to be taken to fight climate change, even if it might put them out of a job. Folks who work for the UN to tackle world hunger want world hunger to end, even if it puts them out of a job.
I don't think rank-and-file workers are psychopaths.