OK, you didn’t get into the college that you really wanted. But you did get into your safety. Stop thinking about transfering.
Don’t let the dissapointment of not getting into your prefered college define your life from here on out. Make the most of what you can control, which is your performance at the college you are at. Show your professors how good you are. Do well and then the doors of whatever career you want will open wider. Don’t do well and those same doors will close and then where will you be.
Be that likeable person that others will be attracted to. Enjoy your college experience. You’ll feel a lot better if you change your attitude.