I would give it a few days and talk to him again. He says he does support your idea, so I would try again once he has got his feelings out of his system. It could be that he is more just venting than actually saying no to your idea.