The very short version, until I type up a longer version: an ND filter cuts down the light, ideally without otherwise harming the image. Useful when the light is very bright, but you still want to use a wide aperture to get a shallow depth of field. Also apparently super-useful for video stuff, but that's not really my area.