We don’t have a vision of your actual scenario so it would be difficult to give suggestions. Your best bet would be to make an appointment with a therapist who could understand your complete actual scenario and give you proper advice. Also make an appointment with your school advisor to discuss the implications in regards to your financial aid and how change of residency would have impact on your academic credits and college costs. (also your ability to transfer as an out of state resident)
Most importantly you need to discuss all this with your current guardian who is providing you a place to live and health insurance.
With you struggling in school I would suggest focusing on improving your grades instead of focusing on clubs and other social things. You first need to pass your classes. You can always start a club at your school if there isn’t one that meets your interests. Clubs won’t help you graduate and get a job. Community college is to obtain skill sets for a job and is different than a four year college experience which provides more social experiences. People attend community college with either the intention of getting a job after two years or to complete basic class requirements before transferring to a four year university.
My concern is that if you are dependent on financial aid with you dropping and retaking classes that you will run out of it before you are able to graduate and get a fulltime job. You seem to be struggling academically and are not able to handle a full college workload. Without a strong foundation in your basic classes you will struggle if you later transfer to a four year school where the upper level classes especially in STEM will be more challenging with a weak foundation. You don’t want to be on academic probation and later be asked to leave the school due to poor performance.
College is a time to transition from being dependent on family to becoming an independent adult. The challenges you face and resolve yourself will give you the skills to be fully independent in the future instead of relying on another adult. You are not building those life skills.
The scenario of moving to an out of state elderly relative (grand parent) is a bit of a concern because they are probably on restricted income and may have limited mobility due to health issues. Instead of being a support for you, you maybe expected to be a source of support for them. You never know what can happen tomorrow. The scenario may change and they may no longer be able to help you.
My concern is that once you withdraw from school you will never go back to complete your education because you don’t have the motivation to.
Please make an appointment with a therapist as soon as possible. I don’t know what else to suggest.