As the spouse, I would think you're best positioned to provide emotional support. He can get career advice from anyone, but the space to sulk privately and get some love can only come from you. So provide that. If he asks for advice, you can give it, but I wouldn't offer it up if he doesn't ask.