Got a C in a sophomore subject unrelated to my desired major... how does this affect Ivy/Oxbridge chances?

Not sure how that one grade will affect you, but your chances are the same as every other unhooked applicant. < 5%. AKA- low. So apply, but have another plan ready.