Yes, I would pursue an MA in sociology. There isn’t really a differentiated degree program for CC teaching, but I would try to find a university that would grant you some kind of a graduate assistantship. At most schools, an assistantship would pay for some or all of your degree, and you would work a small number of hours each week for the department under the supervision of a full faculty member. The best assistantships allow you to teach introductory college courses under the supervision of the full faculty. This will give you both experience that will really help when you go to apply for jobs and the chance to see if you like teaching college.

You might want to check at some of the community colleges in your area. In some fields they like to hire full PhDs rather than MAs. They can tell you more specifically what they are looking for. Often you have to start out as an adjunct. Adjunct instructors teach only one or two classes each term and are not considered full faculty. They may teach up to full time, but usually do not. Adjuncts are paid a flat fee per course they teach, and do no usually receive health or retirements benefits from the college. Full-time faculty teach a full-time course load (usually the same number of hours as a student must take to be considered full time), which may be adjusted due to departmental needs or research projects. Full-timers are a contracted employee of the college and receive full benefits. They also get the prime office space and better course assignments.

College students are a lot of fun to teach. If you do it right it can be a lot of work, but it is not as stressful as many other jobs. You have a lot of control over your courses usually, and your students are adults so you have a lot more freedom and you can give them much more responsibility.

Good luck!