This sounds similar to my story. I had profound spiritual experiences similar to yours starting from the age of about 8 or 9. I believed that they all meant that the church was true. I also served a mission and had tons of spiritual experiences, but many things were added to my shelf. I came home believing in God more than the church, but still believing in the church and having a strong testimony. My family had always seen me as the spiritual giant in the family. They never thought I would be a GA because I am a woman and women can't have any aspirations that are even remotely similar to those of men.
My husband left the church a couple years before me and that was the most heartbreaking experience of my life. Over time, I became more familiar with the problematic history and doctrines of the church. I desperately clung on to my spiritual experiences. Learning about the details of polygamy and polyandry is ultimately what broke my shelf. I, too, came to realize through prayer that none of it is true. My spiritual experiences were no longer matching the church's teachings. It was terrifying. I finally had a similar realization that these spiritual experiences don't mean that the church is true. I was still certain that God existed, though. After about 6 months of still believing that I "knew" God exists, I applied the same logic to my spiritual experiences and started to realize that just because they were real and I experienced them, it doesn't mean that they came from a divine being. Maybe your path will be different, but that is why I am full on agnostic now even leaning towards atheism.
I was also (and still am) terrified at breaking my parents' hearts, but it has gone okay so far. I have no interest in trying drinking or living much different, so that has been a comfort to them. Just keep showing them that you are still you. You are the same person with or without the church. Learn to love yourself for the person that you are instead of for the testimony that you have/had. That was the hardest thing for me. My whole identity was wrapped up in my testimony.
Things get much better and it has only been 10 months since I stopped believing. Good luck