Posters have commented here that even MPHers coming out of top programs like JHU have problems finding jobs coming from certain concentrations like global health, it isn't necessarily where you went, but your other jobs skills and experience and specifically what hard job skills you learned at your MPH program. Definitely Emory is a very good school, but if somebody is looking for somebody with an Epi background and can work with certain stats programs, if that is proven by one candidate doing a concentration in that, then they aren't going to go with the behavioral sciences concentration from Emory. Public health reputation is actually kind of local in a lot of cases as each region of the US has different public health issues of prominence and local health departments know that students going to a regional school get a good background.
Many people come in getting the MPH with additional education and a health-related career, and it might be harder to use the MPH as a stand alone degree. From one "top 10" MPH program the students complained that it was nothing more than "more college" and was unclear what the high tuition was for. Definitely, high tuition and a fancy name doesn't necessarily mean a stellar education, before COVID people could get online degrees and get jobs but people going to brick and mortar schools would fail finding a job in their area, so your luck varies a lot. If the programs at Emory and JHU and other top schools are online . . . you're not getting the same networking and in-person class experience, for a lot of public health students you want to hear the inspirational lectures and thought provoking conversations.
In the past hospitals have often hired MPHers, but with decreased patient volumes for non-COVID related reasons, budgets are stretched thin, that might make it harder overall to get a job as an MPH. Also, the MPH degree is very general, I think if you are fantastic at a certain subject, and love it, like mathematics, then get a MS in BioStats, or if you love psychology get a masters level in that and simply look for public health realted jobs, most people working in public health, (including healthcare workers and logistics and scientists) don't have an MPH. The jack of all trades is master of none.