Oh, of course there are exceptions (though note that many, such as Fuld and Crittenden, have MBAs from top B-schools), and there are probably very few jobs in the country where you absolutely
must have a degree from a top university (president of a top university might be one of them). Given how many more students graduate from average/state schools, there will always be a fair number in any field, but in the fields I named Ivy league grads still dominate, and if you really want a career in one of those fields you'd almost certainly be better off going to a top school. But with what those fields pay, the debt wouldn't be so unbearable.
Personally, I went to a smaller undergrad and graduated with very little debt. It did limit my career options considerably, but didn't hurt my law school applications, so I decided to go with a top law school depsite the debt.