Hereford’s former munitions site wins support