Honestly I don't think you could have handled the whole situation any better, and I don't really think you ruined anything. It's good that you set some boundaries for yourself and that your communication with her was very clear as far as your feelings for each other. I definitely think there is/was a version of this where you could still be friends, but she's just not ready for that yet and yes it sucks, but I think you already know it's much better to be around people that also want to be around you. She needs her space and you need yours, give it some some and maybe you rebuild that friendship, or maybe you find someone even more fun to be around ¯_(ツ)_/¯