So is it really ingame how that looks works?

It pretty much just "paints the textures".

It's a shader effect that detects when it is "snowing" and plays the accumulated effect. Which is why they don't need separate models or textures to do it.

There will be some pretty impressive shaders with mods that will likely have interactive snow, possibly. Depending on DX11 hacked effects.