Wet means the organ was recorded with mikes at some distance from the pipes so that reverberation gets picked up.
Dry means the pipes were recorded with the mike right in front of them so no reverb is recorded.
For home use with a pair of monitor speakers you would need wet to hear what you'd hear in the actual church.
Dry samples need added reverb and sound best with multiple speakers.