SSRI's can absolutely work. But they almost can never work on their own. You need behavioral therapy, either CBT or DBT. It also takes time to find the correct mixture of drugs that will allow you to succeed in therapy but even that isn't a free pass, you still have to apply what you learn in therapy to every day life. You have conditioned yourself to turn to suicidal ideation whenever something doesn't go the way that you feel it should. No amount of drugs will stop that from happening. You must uncondition your brain to stop doing that. It's extremely hard work. I myself have had many successes in therapy and I worked my ass off to get there. But ultimately, there were just too many barriers for me to overcome and accept. Nothing will work if you don't try. And that's a decision only you can make. Whatever you choose, whether that be to continue on this path (which is the path of least resistance, it's painful and suffering but it's comfortable and known), or decide to CTB, or decide to put in work to change the status quo, I wish you the best of luck and sending good vibes your way.