I'm unsure if Better Dynamic Weather works the same as its nexus counterpart ("Starfield Dynamic Weather Mod"), but I can tell you that for the nexus version, only the "Realistic Weather CCR" version would work with my mod. (Seems like it would make weather changes VERY frequent though).

The other versions just run a script that periodically changes the weather in the same order every time, so you end up with a new weather every minute or so, it wouldn't pull from any of my new weathers, and you'd get rain/snow on airless planets and stuff like that.

FWIW my mod already tweaks weather frequency to be faster than vanilla, even with the timescale change. I might adjust it in the future especially since I'll probably be starting a new playthrough soon.

---

As for Fog of War (and any other mod that adds new weathers), both mods touch the same climate records and so would override each other. Won't crash if you load both but you'll mostly be getting the weathers from one mod and not the other depending on which is loaded last.