The subarcsecond mid-infrared view of local active galactic nuclei: II. The mid-infrared--X-ray correlation