My kid just earned her MS but had her "dream job" 4 or 5 months before she received the degree. So like everything "it all depends".
I turned down an ivy school for my (much cheaper) State U MBA some 20 years ago. (I had a kid and a mortgage.) I'm still not sure it was the right decision. Was it worth it? Dunno -- but I had FUN! I still use some of the stuff I learned on occasion. I wouldn't recommend spending a ton of money on a second or third tier MBA degree.
ANY job where you’re a productive member of society and not destroying others is respectable.
I don’t care if someone cleans tables and takes out the trash, they’re still doing something and I still have respect for that person in that regard.