Sunny,
It's my understanding that kids who maintain a sport have lower incidences of behavior problems and addictions. But it should be OK to play the sport and enjoy it without your GS feeling he has to be a star. Maybe you can make that clear to him, be the person to support him unconditionally and encourage his love of the game. His unhappiness comes through loud and clear in your email, and I hope you can alleviate it. How sad for him that his parents will not support the sport he loves.
I am certain that my football playing son would have gotten into some kind of mischief, maybe serious trouble, if he hadn't loved the game and spent so much time at after-school practices. I don't particularly like football, but he was determined to play and I saw that keeping a boy from his sport was going to cause big problems of rebellion. Eventually he got a part-time job and paid for some expenses himself, but really it was a school team (at a very good high school) and we never experienced much expense with it. Maybe your GS could get a part-time job, anything, delivering papers if he is too young to work at a regular job. If he had to pay some himself, this also would show you motivation; $200 isn't a lot to have to earn. If he was willing to do that, perhaps you could cut a deal with the parents to loan him the money (school is starting soon) and he would pay you back from his earnings---privately, out of your GS's earshot of course? These earnings also could go for his equipment.
Sunny, if you cannot afford this and the parents won't pay, are there pickup hockey teams in the area where he could play without the pressure of having to be a star? (I realize that won't be the same.) Can you find ways to encourage and support him that don't involve money?
As for the "star" thing, actually some kids do make it. My other son tried out in an international competition. He thought he had no chance against the other 1,000 applicants. He won a coveted spot and twice. This set the stage for admission to a very good college, a graduate degree, and his present career. The first money he ever made as a professional was payment from Harvard University. But he wasn't pushed into this during his childhood, nor would he have been made to feel bad if he hadn't gotten this honor. We treated it as a lark, with no expectations, but thrilled for him when he won. The training he needed did involve financial sacrifice on our part as he grew up. Now it is paying huge benefits to us all. Kids should go with their loves. Sports provides wonderful training, discipline, and keeps kids physically fit (heaven knows they need that, with all the junk food availability today.)
Please let us know how this works out. In any event, he is lucky to have you, his grandmother, the lady that loves and understands him.
Kathleen