If you’re looking for the work to support you, you may be asking too much of it. We create in service to art, not for what we can get from art.
You may yearn for success as a way to leave an unfulfilling job and support yourself through your passion. This is a reasonable goal. However if the choice is between making great art and supporting yourself, the art comes first. Consider another way to make a living. Success is harder to come by when your life depends on it.