You have done what you can. You outlined what you need and gave him a path home. It's up to him to actually walk it though.
3-6 months sounds like a long time right now, but if you get your R back on track and spend the rest of your lives together, that time will seem like nothing.
I cannot believe he spent the money you gave him on cam girls again!!
When are you headed out of town to see XF's mother?