It all depends on your portfolio. To attract work you need to show what you can do. It is completely possible, AV club mentioned the Marc Newson example. Of course it is also ‘possible’ to be the next Michael Jordan 
… if you want to have a smoother (but more costly) transition going back to school would probably be helpful. Of course a masters takes 2 years and lots of cash. An alternate could be setting aside 2 years for yourself and working on a killer portfolio, building some furniture or other things, and seeing what happens. As an employer I would totally be open to hiring a sculptor if (big IF) they had the right skills and creative problem solving disposition.
Side note, the automotive industry often hires sculptors for clay modeling.