I would just be supportive. Everyone's different. Everyone's brain functions different and there are thousands of people with the same jobs that have wildly different accomplishments AND mistakes in their time. The story here doesn't sound uncommon, actually. I'd also say what he is feeling right now is normal and it's good you are being supportive even if it isn't entirely heartfelt.