May I ask what state/country you are in? California has a website called ASSIST that shows you what classes to take if you want to transfer from a community college to a CSU or UC. Also, may California communit colleges have Engineering, but you probably will want a bachelor's degree for jobs.
The UK has more majors, but if you can't afford to leave the country then I guess that's not really helpful. I was in a similar position myself (I wanted to go to University of Glasglow because of their Parasitology major, but my family would never forgive me if I left the country). There are also some UK schools that take FAFSA, so if you qualify that would reduce your cost (Glasgow is one of them).
As long as you take the right classes, it is definitely possible to transfer into any of these majors (except maybe Parasitology since that it hard to find). Try to find the program you want to transfer to first so that you don't waste time taking classes you don't need. If your state has a system like ASSIST, use that to look up the classes you need to take to transfer or look on the websites of the programs you want. You might also want to meet with a transfer counselor at your community college for some direction. For example, you wouldn't just take a bunch of Earth science classes for Meteorology. Think about what the first two years of a four-year program is like. You will take general ed like writing and humanities, as well as your core science like chemistry, biology, and physics, and college level math like calculus or linear algebra. The upper division classes are usually the more specialized ones, like Meteorology classes or Microbiology classes, which you would take after you've transferred.
You will probably end up taking fewer higher level classes than you would like, but after you've transferred is when you get to the cool stuff. Make sure you complete any breadth or general ed requirements at the community college because colleges want to see that you've taken equivalent classes to what a lower division student would take at their university. They will also want to see that you are likely to succeed at a four year university and are not starting out behind, so you will need a high GPA and have completed all the classes required for transfer admission.
Does this help?