I know this thread is old, but I just wanted to say that I took the SAT twice (incidentally, I also got 2040 the first time around :D), and I did SOOOO much better the second time around, even though I didn’t study as much…it’s definitely worth a shot!
But you also may want to note that most Honors programs don’t accept applicants that have already matriculated at a different college…
commonsense: To the best of my knowledge, they don’t actually require SAT scores.