Zuzu, he is hurting and you cannot fix it. He is the only one who can. You can support whatever solution he comes up with, but you can't fix how he feels or how he sees his life. There are career counselors and life coaches and people who can help, but that's not your job.
Personally I admire that he has stated that his life is lacking in passion and that he doesn't want to live that way forever. Many people would just suck it up and not say anything and go on like that for decades.
But he has to go out on that quest to find the occupation or activity that will inspire him and give him the energy to go on. You can encourage and support him, but you cannot go out and capture the head of the dragon yourself.