Honestly, if there is no emotional value attached to that car, in his position I would just sell it in the US and buy a new one in Canada. That would be the most straightforward way.
What everyone here is saying is that if you want to import the car, you need to own it at the time you cross the border. Based on what the bank told you, your husband most likely does not own the car at the moment so he cannot import it.
I'm assuming that you have a lease contract. That means that the bank owns the car and lets your husband use it in return for monthly payments. Once it is paid off, your husband will take ownership of it.
If you really want to bring the car, you need to get however much $$$ that is still outstanding, buy the car from the bank/leasing company and then import it to Canada.
If you do not have enough $$$, get a loan that is not tied to the car and use it to buy the car from the leasing company, then import it.
he needs a vehicle to bring all of his stuff over for his work. So you don't think there is a Canadian car loan company that would take over a US one?
