Well, first things first, you're neither small nor hopeless - you're in pain.
Er, chronic pain is obv shit. But you're not 'there' yet, you need to push with docs for a proper diagnosis, and treatment/management. Sometimes it is tough, but you need to be strong to advocate for yourself.
My pain is in a different department, as it were - I have pain in my side from some surgery. There are painkillers, there are devices like TENS machines, there are meds to try to effect the way that your nerves expect and feel the pain, so it is not all doom and gloom! There are also pain clinics, full of nice helpful experts.
In terms of how I cope with it emotionally - perhaps not so well at first. It was tough for me as it was so invisible - previously I was ill and looked it, hence others knew. But now I am better but still in pain. Although I do not want pity, and not really sympathy, it did bug me that no one could see the extent of my pain - I guess I just wanted it acknowledged!
But I am doing well now, I find ways of managing - eg I have a new sleep habit so i don't wake myself up in the night in pain; I am much better at knowing what clothes will hurt me the least - and no longer care about things I can't really wear now), and I take regular exercise, which helps a lot.
It will get better, you're very probably at a low ebb now, so onwards and upwards!