If you include the invisible homeless in the group, you can probably say that the majority of the homeless don't have mental health issues. It takes functional mental skill to not be a visible homeless person.
The highly visible homeless probably have significant mental health issues. Mental health issues have a nasty way of completely destroying your social network. If someone doesn't get medical help before they hit bottom, they're in real trouble.
The biggest problem is that the "homeless" aren't a monolithic bloc. So, Amdahl's Law is at work--even if you completely eliminate one class of homelessness--you still have 80% of the problem left, it looks like you didn't do anything and everybody gets angry at the waste of money.