He's only human op.
He probably has been supportive to the best of his capabilities and limits.
He is struggling too. Not just you (sorry that you are)
He may have told you the truth about everything. He may have found you attractive previously, and now he doesn't.
Men and women have physical and attraction preferences.. weight gain or loss, illness, etc... can alter a person's attraction to their partners. You wanted an answer, and he told you the truth. Don't ask if you know you feel like you may be hurt and offended by the truth.
Being a caregiver is exhausting, tiresome, time and life consuming. The transition from partner to caregiver is hard on him as well.
Caregivers get burnt out, and often providing care to and assistance to another is challenging and not everyone is cut out for it.
He's only human and he isn't equipped to deal with your mental health. He isn't equipped to manage your mental health. He provided a resonable solution to your suicidal threat and outburst (perhaps you were testing his reaction and response). He has told you to contact your mental health team. He can't "fix" you.
It's probably best if you two ended things.
You really should take the time without a relationship to work on your mental and overall health. If this is something that you feel is unmanageable, it's best that you don't get into any more relationships...as it will negatively impact any relationship.
You come with a lot.
It's best to end things and focus on trying to improve the quality of your life. No one else can do "the work" for you.