When I had ambitions as a teenager of being a studio "reed" player in LA, my teacher didn't try too hard to talk me out of it. But he did make me start studying clarinet instead of sax, on which he could see I needed little encouragement. And I had begun playing flute, so that was beginning to get covered.
He himself, in much earlier days in NYC, had been a good-enough sax player to ensure constant gigging*, but even then was such a nervous type that he took up bassoon as a fall-back, and was a credible orchestral player (although he said he always hated the instrument).
But he did warn me that in his estimation, no matter how good I got, I would ultimately regret the path because I would simply get tired of it. As I look back now, I'm sure that he was right. And yet I have known many players who are still doing exactly what they want, and more power to them.
*in fact he was by all accounts superb, which offset a tendency to be insufficiently diplomatic with contractors and other musicians.