Hey, so this is common, and happens to many of us out there, so you are surely not alone. Even before finishing this thread, it was pretty obvious to me that feelings are involved
(there is nothing wrong with that!).
I am one of those gays who falls completely head-over-heals for inaccessible straight guys. I am no longer friends with a couple of them; and still best friends with like three of 'em, fortunately. Historically, I am also one who knew that my man-crushes weren't accessible, so I never pushed the boundaries on the outside, because I always felt like the risk wasn't worth it in exchange for life-long friendships. Unfortunately, though, I always had to internalize my feelings, angst, and unrequited love, and it was turmoil, however, in each and every situation, I just worked through it until I fell out of love.
As I have gotten older, I have also learned that friendships (or ANY kind of relationship, whether it be friendship, partner, spouse, familial) are hardly ever permanent, esp without a give and take. Yeah, in familial relationships, you are bound by blood, but if you dig deep, that doesn't necessarily mean that there is a true relationship there. With regards to FRIENDSHIPS, there are categories. I always abide by this mantra -
1. Friends for a reason
2. Friends for a season
3. Friends for a lifetime
https://considerthisradioshow.com/reason-season-lifetime/
In other words, ppl naturally fall into our out of your life, regardless of the efforts you put into it - because it has to be a two way street from the receiving end. If there is an imbalance, it's OK, but you have to be OK with it, and that energy you spend has to be worth it to you.
With my own friends, I have my own boundaries with regards to tolerance; if it's not worth it to me, I let them go. It's not out of anger, or any fault of there's, and normally there is no argument, but it has to be worth my time, because once you give someone your time, you can't have it back. I delete contacts regularly, every year. This is my mantra - if I don't contact them - will I ever hear from them again? Who's going to pick up the phone to gimme a call? Most of the time, good friendships are far and few between, and if it's a strong friendship, it will last a lifetime. That doesn't necessarily mean that you see them all the time, and talk every day, because a definition of a frienship means something different to everyone, so there has to be some sort of common bond and understanding of what that is.
It's OK to consider him a friend, still, if the dynamics have changed, but you have to work through it and accept it, because it's a circumstance beyond your control; you've laid it on the line, and the rest is up to him. Whatever friendship Buzz and Woody have is THERE's. They own it. As do you own your friendship with Buzz. Over time, think about what made it tick in the past, and what will make it tick moving forward. If the only thing is that has kept it going are the feelings that you have for him (that aren't reciprocated), which isn't his ownus, then the friendship is on a shaky foundation, but that doesn't mean that you will lose it. Again, friendships, as with ANY relationships, are constantly changing, are dynamic, and builds on itself over time. If it is strong enough, maybe it will last a lifetime! ...but you never know.
You can't have any expectations on Buzz. It's best to have quality of time by staying off the alcohol. Respect boundaries, if only to not become too dependent. But also respect his friendship with Woody, learn to live with it; don't think too much into every single one of his actions, and "roll with it".
In the meantime, try and make new friends. I know that is hard in itself nowadays, but if that isn't happening, then at least take care of yourself by also just venturing out on your own. Find activities or events, or groups on your own, and live life!
I know that what I wrote about friends and relationships sounds rough, but contrary to how it seems, I am blessed with a few really good friendships, most of them in-place 30+ years.
Karabulut is right-on with what he says.