I am freaking out please help!

If you're currently on academic probation, you'll have to look very carefully at what failing your core chem course will do to that status. You could be disenrolled from the CSU. You need to take a very, very close look at yourself and examine why you were placed on academic probation to begin with. I suspect that the reason you're on probation to begin with is probably related somehow to why you're failing your core chemistry course. Fix the underlying reason and you'll probably do just fine in the long-run.

If you do get disenrolled from the CSU, you'll likely have to successfully attend a semester or two (could be significantly more semesters) at a community college before you'll be considered for readmission to the CSU. You'll have to successfully retake any deficient prerequisite courses and you'll have to be certain that the courses will transfer and directly satisfy the entry requirements for a program.

Being disenrolled from a University never looks good... how you recover from it may help gain you some consideration later.

I have never been disenrolled but I have been on academic probation once. I have failed out of nursing school and recovered from that too, ultimately becoming an inspiration to my instructors and a class leader in the process.