That is nasty, particularly for people who have been long term fans. A real disillusionment. I would not be able to listen to their music again.
It does leave a bad taste and a feeling of deflation. You have an impression of how your fave star will be if you met them, especially when they come across all humble, affable and charming in interviews, and then you encounter them in reality where they are being themselves and...
I still listen to his recordings from time to time, though generally the ones from his early days (1970's). But you're right, the admiration has gone since he showed himself to be just another jumped up little song diva.