Not a stupid question at all, it's the very question I ask myself evey time I turn up on a Saturday afternoon, with four different length spikes to choose from!
5mm is very short, you'd use those on the track. 9mm is still relatively short but would be fine on soft or firm grass if not too muddy, and you'd even get away with gravelly sections. If it's going to be significantly muddy then 12 or 15 would be more suitable, but only if you've got soft surfaces (mud/grass) all the way round. If there is fresh snow, you'd also want longer spikes in for a bit of purchase.