Agree that it would be hard to walk away from an almost full ride college with strong academics, mentorship, research opportunities etc.
Keep in mind that the grass is not always greener on the other side.
–First of all, merit aid is hard to come by as a transfer – can your family afford to pay?
–Secondly, there will be drinking/partying at any college. And any college will have some people that are not interested in that scene. Have you joined any clubs, have you looked to see if there is wellness housing available?
–Lastly, it can work out well but is not easy being a transfer student – many friendships are made freshman year when everyone is new, your peers at the college will be used to the campus/the way things are done etc. while it will be new to you etc.
My recommendation is to first give things another try. Look hard and see if you can find “your people” at the college you are at.