I used to use it in-game when I played G/S, as it was the only shiny I ever got. Then in Crystal, I got another shiny, so I didn't feel obligated to use the Red Gyarados.
Now, it's just for collecting reasons. I just try to get a decent nature and some good IV's and then leave it in my box for later use (trading?) or something.