In the big picture here, what's tragically wrong with bodybuilding is that there is no money in it. Never has been. Perhaps someday that might change although I don't see it in the foreseeable future.
When you say the few top guys make in the 6 figures, just compare that to the top athletes in golf, tennis, baseball, basketball, etc. Those guys are making in the 7-8 figures, some even more. And for the near top pros I wouldn't guess they make that much. I suppose they eke out a living (with no G4P). And unfortunately it's all relatively short lived. By the time you're 40, the contracts most likely have dried up.
If someone goes into bodybuilding just to make money, I think it would be tough road. On the other hand, to me, there is no other feeling like training, watching your body change, and having a result that is breathtaking to look at. Not only to others, but to yourself.