Everyone has given you excellent advice and comments. I will just add that anyone who is about to graduate from college is far from a failure. Try to focus on your success and feel proud of yourself for your accomplishments.
It is JMHO but Bard is a very isolated school. Personally I would be depressed if I had to live there. It is also a very small environment which I think would make it more difficult to find your people. As you move forward maybe look for a larger, more “happening”, more vibrant place to live. I think the more people and activity, the more likely you are to find more options.
You’re almost there - you’ve got this!