Maybe attendance at BASEBALL games is dropping. Baseball is a dying sport. It is far too slow paced for today's society, and thus less and less people are watching it. Being that you said you are a huge baseball fan, that could show why you think sports are dying, because baseball is. Now, it never really will die, look at the MLS no one watches that and it is still around, but it will shrink drastically, especially in like 20-30 years when the majority of its fan base is...ehm...no longer with us.
As for sports players being role models, who cares? Since when were they supposed to be role models? And you are falling into today's media-crazed world. Its very similar to how JFK had mistresses, the press knew about it, but no one raised a big stink about it. I'm sure pro athletes are the same exact way, do you think they all used to be perfect little angels? Hell no.
Fact of the matter is, there will ALWAYS be pro sports, because people will always pay to watch them.