Will a weather failure status update when the weather clears?

Yes. If packages have the failure status on their trackers due to weather, they will automatically update themselves to in_transit if they’re able to continue shipping after the weather clears up.