Im lost

I had been going to Community college for two years and I couldn’t pass any of my classes. I was depressed and had anxiety, I felt super pressure by my family especially because my older sister is the golden child in education, she just graduated with masters. I want to go into nursing but I’m so lost, I was just planning on getting my CNA this summer and then my LPN but my family looks at me with disgust and I have a terrible stomach ache from this stress. What do I do? 😔 I can’t go back to the community college this fall because of my bad grades and i feel so terrible for wasting time. Is CNA and then LPN a good choice? My family hates the living hell out of me so I can’t ask them. I have a headache from researching the whole day.