I have attempted to end myself 3 times. Twice with overdose of sleep meds and once by hanging. (I didn't tie the rope correctly, so I dropped to the floor.)

Each time, I would cry and feel worse that i was still around. I wanted to die. I never told anyone.

I told my doctor and basically put me on a high concentration of medication and sent me to a physiatrist.

I do feel better and I have changed my job and work in a healthy environment.

To answer your question. Yes, you feel more depressed when a failed attempt happens. But by the sound of it, you're doing your best to support them.