Your examples are a bit odd. RedHat seems to be doing fine, and more CentOS users means a bigger potential market for RedHat. There are a lot of success stories of free software communities that seem to be doing fine.
Although MySQL is in a weird spot now, the way it evolved is impressive. Also note that MySQL folks use to explain the dual-license as: "if you make money, then so do I". i.e. if your program is proprietary, no problem, you can link with MySQL, but then pay a licence fee. It was a good model for MySQL, imho.
I'm a developer and contribute/adapt/deploy fundraising and member management solutions that are completely GPL (CiviCRM and Drupal). Any patch I do for my clients, I publish it online, or put in more billable time to get the patch into the original program. My clients understand that they now have a choice of consultants and find it wonderful that we are a ton of people who understand this code. They are more autonomous, can do more stuff, and usually at less cost.
Anyway, the quote from Monthy seems really out of context. Afaik, Stallman finds proprietary software immoral, not profit. The argument is usually made that making money from proprietary software, while it may feed your family, causes harm to others. I don't see how making profit from free software would be an issue.
This said, imho, everyone has to do some compromises in order to survive, but more people succeed than you think.