There is pretty much 0 wet lab work in epi unless you actively seek it, which is what's so attractive about it to me me as well! I am considering medical school but thought I would try this out first because I'm a good thinker but extremely clumsy and just awful when it comes to lab work. I'm sure this is a skill I can develop but it's not something I really like doing. 😵
Where are you from? The terminology is definitely confusing, because epidemiology itself is research! But the difference between "fieldwork" and "academic research" is first off, obviously the employer. It's the difference between working somewhere like the CDC or WHO and studying population data to implement actual public health outcomes through political policy and doing very similar work at a university, but more along the lines of "research for research's sake," though obviously these studies are leveraged in a wide variety of situations. Another potential employer would be pharma companies, and you'd use data there to study the outcomes of the drugs they are developing. There are also a lot of different ways you can go with epidemiology depending on additional training and also just what you want to do, like clinical research. Going into one isn't going to limit your opportunities with the other beyond just the connections you develop, because the skill sets are similar. If you go into fieldwork you could apply to PhD programs and go into academia, but you would still need some academic research experience and that is why doing academic research at the masters level would give you more leverage for the PhD programs. If you go into academic research and do not do a practicum, you could probably almost always transition into fieldwork, but you'll probably have less contacts in that area and it might be more difficult to find an "in" at a place where you want to work.
MS and PhD are "research" degrees and MPH and DrPH are "professional" degrees, so picking one of each is the way a lot of people go. You will have very pretty much the same job opportunities between an MSPH and an MPH, the only difference is that the MSPH is probably going to have a couple of more technical classes and the MPH is probably going to have more general of a base. I come from business so I look at it as the difference between an MBA (taking some of all of the disciplines so you can make holistic decisions and concentrating a bit more in one area) versus an MSBA (technical business/data analysis, not really making management decisions). That may or may not help the way you think about it. However, the MSPH and MPH are a LOT more similar than an MBA and an MSBA.