From what I can see, tenured professor at an elite school is a pretty good gig. But it's a really tough gig to land, may not pay very well compared to private industry (assuming it's in a well-compensated field), and may force their partner to live somewhere the other employment opportunities aren't great because your own job mobility is likely pretty limited.