I worked as an electrical engineer for over40 years and have personally designed and tested hundreds of printed circuit boards for both military and commercial designs, and have reviewed many more customer PCB designs as well. Audible noise coming from a CCA is pretty rare in my experience, but I have seen (heard) it. If I recall correctly the last time we tracked it down to microphonics in a multi-layer ceramic capacitor. Had to redesign that part of the circuit to fix it.
I can remember doing those vibration tests on a military computer. System failed almost immediately. Opened the chassis and the inside was littered with sheared off components, mostly larger electrolytic capacitors. We had to encapsulate them in silicone.