Passion and loyalty are admirable, but excessive emotional investment can create tension, as in your experience with your brother. The way you describe his behavior as "emotional garbage" is a strong term, but it captures the frustration you feel when his mood sours due to a team's loss. Imagine someone letting the outcome of a game negatively impact their entire week and their relationships with others.
The distinction you draw between passionate support and taking it out on loved ones is crucial. Cheering for a team is great, but it shouldn't come at the expense of family harmony. The humorous detail of him being a non-betting fan adds another layer. His intense emotions aren't fueled by financial risk, but by pure passion.