A note of encouragement:
My undergrad sociology mentor recently told me they got into 2 out of the 10 schools they applied to. Another undergrad mentor in a related field got into 1 PhD program, and now they both teach at an R1. These are two of the smartest people I've ever met, and they are both extremely successful academics. I was shocked when I first heard they had faced so many rejections- it made me realize that after a certain point, it's a numbers game. No matter how many years of research experience, degrees, or publications you have, so much of the admissions process comes down to luck (not to say that working hard doesn't matter, just that there are no guarantees despite how hard you work). It's such a difficult feeling to manage when you have already done everything you can and now your fate is in someone else's hands. But as the second mentor has been saying to me for the past few months, "don't worry about how many acceptances you get, you only need one because you can only go to one."
In case you or anyone else needs to hear this, your value as a person, aptitude for sociology, or potential for academic life have nothing to do with how many programs admit you. You are worth way more than your work.