Should I just give up on college?

OP, a defeatist attitude will get you nowhere in life. You are quite capable. Keep working towards your goal.