I am a pharmacist in Texas. There are certainly advantages and disadvantages to the job (as with any).
There are third shift opportunities available both from hospitals and from 24 hour retail places. I think becoming a pharmacy tech would be a good fit from what you are describing. The schedule opportunities would be the biggest benefit for you.
Many retail pharmacies will allow you to work as a clerk at first where you will work the cash registers and do other non-technical work. This is a fantastic way to get started and immerse yourself in the field. The MA job you currently have will certainly help.
I really would advise against going to a community college if you can get your foot in the door at a pharmacy as a clerk. The CC price is far too expensive for something you could simply study on your own for.
You will want to become certified with the PTCB. They are the certification body for pharmacy technicians and create the exam you will need to study for. I do run an online pharmacy technician study guide that could benefit you. Find it at www.udemy.com/pharmtech You can use the coupon code of grow50 for 1/2 off.
Please don't hesitate to contact me if you have any more specific questions on your situation. You can find me on twitter @pharmtechcourse