Hmm. Tripod stops camera motion, can eliminate tremor's effect. Tripod doesn't stop subject motion.
Years ago I surveyed most of the top aquarium photographers in the world, all much published, all highly respected, about their practice. Short answer, 100% used electronic flash for illumination, none used ambient darkness. Small mobile subjects, magnification around 1:1. This was in the late '70s, before digital came in and long after electronic flash was practical. One of the people I surveyed had started in the '30s with a Contax and bright daylight. He was delighted to have been able to replace the Contax with an Exakta and daylight with electronic flash. There are a few hints in this story.