Yes, you can enroll at StateU, work to raise your GPA, then apply to transfer to a better-fit institution. You have a clear story to tell, so don’t worry about how it might look.
What will you do if the only place you are admitted this round is StateU and if later transfer applications fail? Do you have a plan, and sufficient focus, to get through a degree program at StateU so that you can move into post-college life?