You can compensate by demonstrating that you’re academically capable by taking college courses and doing well or showing that you’re half-intelligent through extracurriculars. I compensated for my failures in freshmen bio by publishing a couple scientific papers in peer-review journals; my friends made up for their poor cs grades by competing in usa computing olympiad. You can also try lessening the blow and explain your reason that you did so poorly in comparison to your earlier grades in your essays. Can I ask your reason why you’ve done badly in those two years?
Otherwise go to a mid-tier college and just transfer if you don’t feel like you fit in academically there.