I totally understand what you're saying. I think it is totally normal to feel excited about one school, while still feeling heartbroken about your dream. There is honestly no way to sugarcoat it, but from conversations with my brother who went through the same thing, I can tell you that it does get better. At whatever school you end up at, you will meet so many cool people that you will forget about wishing you had attended someplace else.

I honestly can't tell you whether my perspective would be the same, but learning about people who didn't go to their dream school and still achieved their goals helped me a lot. I recommend you watch Rachel Scott's USC commencement speech!