Dude your career counselor is a fool. Awful advice.

Fire him and get yourself to a doctor and proper therapist pronto. You are worthwhile and your brain is telling you lies, like any proper health condition you need to get some medical help with it, nothing to be ashamed of.

You are worthwhile don't forget it. You can and will get better, go sort out some help and everything in your life will improve.