"I called the child support agency (Burnett County) 3 months ago and was told they've given up trying to collect, that he's "unemployable."

I don't think there's anything you can do now. I would continue to call regularly, make sure they keep tabs of his circumstances and if they change for the better (e.g. he wins the lottery), you should be able to collect.