Tipped over, open hives, at night is a nightmare. I don’t do a lot of hive moving, but I’ve had a lot of my foam hives come apart when trailering them. Thousands of bees from multiple hives end up massing all over the trailer floor. At night the bees crawl. I don’t like bees crawling on me, it’s too easy to get stung. I have been surprised how well the bees have recovered in the daylight. Had to leave the trailer at the yard many times, but eventually the bees seemed to all find their hive (or some hive?) to join after the chaos.
I think you made the right call, but I’m not an expert on transporting bees; far from it!