Wet vs Dry Chain lube

What's the difference and why does it matter?