First, this isn't true. Plenty of people make a living doing each of the above.
(Art is somewhat of a special case, because some will say that what you're doing isn't art by definition if it's attached to some functional purpose like a business model. But you don't have to listen to those people.)
Second, these things aren't cheap because they're not valuable. Water is cheap. Water is also necessary to life. It's immensely valuable. What makes it cheap is that it's easy to provide, so competition drives prices down. People aren't going to pay a lot of money to get something valuable if they can pay less to get the same value elsewhere. Value isn't the only thing that matters when determining price.
> There are dozens (hundreds?) of successful open source projects that have tried to become even just modest commercial enterprises, some very seriously. Results aren’t great.
Are results much better for normal people trying to start businesses that aren't based on open-source code? I'm not convinced they are. Businesses are hard.