Nature of magnetic excitations in the iron pnictides and its pertinence to superconductivity as studied by inelastic neutron scattering