If you're willing to relocate for your wife's job, does that mean you can survive on her income? If so, then you're free to pursue what you really want to do.
Is it that you need the second income, or that you feel useless not contributing? If it's the latter, dude, be a kept man and chase your dream. No one gets rich working for someone else. If you've got fame and fortune in your future, you've got to work for yourself.