If you keep waiting for him to have funds, he will be there forever. There is no "We" in this situation. He is a big boy, this is his issue to resolve, not yours.
His drinking, pot and other activities cost lots of money, it is up to him, not you.
November will turn into December. December into January and so on. Sounds like you are trying to hang on again and praying for a miracle, that asking him to move out will change him...it won't.