I think Ronnie, like Stephen Fry, suffers from bipolar disorder, so maybe this was related to his illness. I agree it might look disrespectful to the game and to people to whom that's a lot of money.
He always says he likes to entertain the crowd, and the crowd loves a maximum, so I'm surprised he didn't complete it. However, perhaps the excitement had already been achieved and he was just making a point to the organisers of the tournament.
Snooker players dont get a lot of money compared to other sports stars.