Yale Law School is sui generis. A full majority of its very small classes go on to clerk at the federal appellate level. While tenured law professor is still something of a long shot even for these top-of-the-top it's not the powerball lottery ticket that virtually all the rest of academia is (they average around 3-4 tenured professors per class of around 200), and there are other fulfilling career tracks uniquely open to people who went to Yale and then clerked at the appellate level.

For other schools on your list it's a different story. They certainly have a better chance, perhaps even a good chance, of getting the BigLaw job golden ring than most law graduates. But in my observation that's a bit of poisoned chalice. It pays well but the work is mostly tedious, the hours are very very long -- with no slowdown as your career advances -- and the atmosphere is extremely stressful.

There are some good public interest jobs for people who for whatever reason aren't money driven (usually because they have money already!) but the competition is fierce even for Harvard and Stanford grads because of all the burned out BigLaw associates looking to get out. Although the jobs are often interesting and sometimes fulfilling, they almost invariably require long hours. Almost all legal jobs do.

A bit less so, but still yes. Yale you're probably okay, but at Harvard, Stanford, and Columbia you're still going to have to be in at least the top half (maybe top third) of your class to have a good chance of getting a job that can cover your loan payments, and that job will be at biglaw and you will almost certainly hate your life. If you can get a full ride to a top 14 school, it's probably worth going (these exist, but are extremely uncommon). If you get into Yale, that's probably also worth it (the way smaller class size compared to Harvard or Stanford helps a lot). Other than that, law school is probably a bad idea.