Well, if you're very asleep, crazy or drunk and people want to "bring you back" they tend to throw water at your head, so I imagine that "go soak your head" implies that it needs to come in contact with water to function properly as in one of those situations.