Yes and no. The problem you have may be this, every time you reload a savegame (say you missed that perfect one kill torpedo shot)
the weather timer is reset back to zero.
This means you must wait for 48 hours in game time for the weather to randomly change states without a reload (and about 8 to 12 hours for the transition time). Even then, randomly it may still stay bad weather. 50%, 25,% , 12.5% etc. good/bad flip.
I had patrols where by bad luck 14 days of storms (1/8 chance).
But most patrols are not that way. Do not reload savegame quickly for missing a torpdeo shot or your weather will remain static forever.
Go at least 48-72 hours in game per play session without reloading a savegame.
AI does not cheat by vision through fog, it does have radar on its escorts destroyers that can see you through fog.