If you can’t get in with your advisor before the withdrawal date, then find out from the bursar and from financial aid if there are any financial repercussions to you withdrawing from this class at this point in the term. If there are not, or if you can handle them, then withdraw. If the financial penalties are too large for you to deal with, stay in the class and take the F - your financial aid will cover this F.
When you retake a science class, do a lot of research into those you look at. Don’t trust what one student tells you. Their strengths are not your strengths - it may be easy for him because he’s great at conceptual, while he’d fail a class that’s all about memorization. Find a class that is set up to suit your strengths (memorizing terms, for example). Get a tutor as of week one, and work with that person regularly for the entire term.
As you do your research for a class, see if there are any professors teaching these science classes who are known as amazing teachers. If you can find one, you may want to try very hard to get into one of their classes, even if normally, the subject wouldn’t be something you’d pick out of interest.
Since you’ll be doing this research now, consider sitting in on one of each of the classes that interests you. Get a copy of the syllabus as well, so you know what’s involved. Have a look at the textbook in the bookstore. Really check each one out.
And consider avoiding anything related to physics - so no astronomy, no meteorology, etc. But if your college offers something related to life and that requires a lot of memorization - so maybe anatomy? Maybe botany? Avoid any classes that are major pre-reqs for programs (so maybe not biology, for example.) Again, check these classes out quite thoroughly first. And check to see if your school considers any non-science classes to actually be science. You and someone else mentioned psych. Also look at anthropology.