Most of the adults and virtually all of the students on this site can probably recall having been rejected by their dream school. I was so miserable when I was rejected by my dream Ivy, and then was very happy at a different Ivy, which turned out by coincidence to have the best program in the country for what I wound up studying. It will be okay. It will work out. You will go to CMU or Columbia, and will likely be very, very happy there, and very successful there.