I've been shooting macro for a while now, so shallow DoF is just part of the reality of this type of photography.
But, after doing some research, that Laowa 180mm macro isn't a good choice for shooting bugs/bees as I want to do. It has a unique dual mode AF where it only will AF down to a certain distance (30cm to 1.5 meters), then it's manual. Not what I want. It's a very good lens, and very reasonably priced too. I like the other Laowa lenses I have (2X and 2.5-5X), but there's no point in buying this one. Those are manual focus lenses and won't work for bugs so well. They could be used, but the success rate would be low. Well, lower than AF, which isn't great either.
I have a Raynox DCR-150 macro lens I use on my macro tube setup and decided to try that on the end of my 70-300 G. That means I can't mount the flash ring on the end of the lens, so I mounted the flash bracket that came with the Godox MF12 flash dental kit on my camera. It's a bit unwieldy, and will take some work to get used to it. I think I'll be able to swing the flashes in closer to the lens to reduce the leverage they apply. Should be able to reduce the power required by the flashes by doing that as well. When shooting in continuous mode, at high power (1 to 1/2) the flashes can't keep up with the exposure rate.
I took some test shots in my apartment, and it's going to be a challenge using this setup. DoF is short, probably just under .2" (5mm).
Here are a few test shots.
I took the diffusers off because they really increase the flash power required. I might need to come up with another diffuser I cobble together. The exoskeleton on insects might reflect too much light. Bees won't be quite as bad, but the potential to blow out areas is there.
My A7R IVa isn't the best choice for this type of photography either, but it's good enough.