You did the right thing. You put the ball back into his court and if he wants to be completely transparent with you, he will give you the password. He isn't thinking that you already have connected the dots of many of his activities. Yes, he should be embarrassed about how much money he has spent foolishly when he could have been contributing more to the family.
Continue to process what he said. I wouldn't say another word about it unless he brings it up again. He needs to understand that you are more than willing to assist in repairing his car, but he needs to be transparent as well.
Sit quietly, the answers will reveal themselves when you least expect them to. The past is gone, the present is a gift and you need to focus on today, allow the future to reveal itself when it is ready.