Sorry this is happening. Please stop enabling him. Please discontinue focusing on his "childhood trauma". The past can't be changed and it's no excuse for unemployment and drinking. Please stop entertaining this, it does more harm than good.
Please try to suggest appropriate solutions such as detox, rehab and AA. Please also try to suggest he see a physician for an evaluation of his physical and mental health and get some tests done and ask for a referral to a licensed qualified therapist for ongoing support and sobriety help and especially suicidal ideation. Mental health is not a do-it-yourself project.
Please step way back. It's not your job to "find his purpose", please get help and support for yourself. Therapy for yourself could help you get out of enabling and fixing mode and help you stay in your own lane and heal yourself instead.
https://al-anon.org/newcomers/self-quiz/adult-quiz/