I’m sorry that you’re going through this difficult time. Your disappointment and difficulty in embracing this new path are absolutely understandable. That being said, it sounds like you’ve made exactly the right decision given the financial situation.
It’s great that you already see some of the positive aspects of the school you’ll be attending, and continuing in that vein will absolutely help you to succeed there. I recommend that you follow the same steps with “door #2” as you did with the first school. Connect with fellow students (incoming and returning), professors, and others on campus who share your interests.
You will find many, many stories on these forums of students who were unable to attend their “dream school,” but who absolutely thrived where they landed. I am confident that once you’ve had a chance to work through the feelings of loss and disappointment, and when you begin to embrace the new opportunities ahead of you, you will have one of those success stories to tell! I wish you all the best.