An optical spectroscopic survey of the 3CR sample of radio galaxies with z<0.3. II. Spectroscopic classes and accretion modes in radio-loud AGN