Let me assure you you are not alone! I've had migraine for 21 years now and remember when my two boys were young and how difficult it was to manage with migraines. Being a parent is hard work enough without having to suffer intense pain while your trying to do a good job! My kids eventually became used to seeing Mummy with her head under the sofa cushion or vomiting into the loo 20 times a day (gross I know, but true!) and they learned to amuse themselves when I was completely incapacitated.
Like you I used to be very outgoing, I worked part-time and liked to be sociable. Now I can longer work as I'm ill in bed for 3/5 days at a time on a very regular basis. I am no longer as sociable either, not by choice but because loud crowded places are a migraine trigger for me. I have to keep my life as quiet as possible. I have also stopped taking all preventative and over the counter painkillers as nothing makes any difference for me anyway. However I would recommend speaking to your doctor about triptan medication to abort your migraine attacks. These work well for me and are a godsend for times when you have a migraine and have something unavoidable to do that day or if you are in intense pain and can't stand it. I use Zomig for those times but am careful about how often as I am worried about rebound headaches. They don't work for everyone but are worth a try.
Things that I found have helped me have been to identify my migraine triggers and avoid them. Eat a healthy diet with as few processed foods as possible. No artificial sweetner or caffeine. Keeping my sleep routine to 6 hours a night (any more and I have a raging headache all day the next day). My hormones play a huge role in my migraines. There is not much I can do about that but it helps to know WHY I have the migraine! I also take a daily magesium and iron supplement and these seemed to help a little.
Hope this helps a bit