The unique opportunity to study and control electron-nuclear quantum dynamics in coupled potentials offered by the resonant inelastic X-ray scattering (RIXS) technique is utilized to unravel an anomalously strong two-electron one-photon transition from core-excited to Rydberg final states in the CO molecule. High-resolution RIXS measurements of CO in the energy region of 12-14 eV are presented and analyzed by means of quantum simulations using the wave packet propagation formalism and ab initio calculations of potential energy curves and transition dipole moments. The very good overall agreement between the experimental results and the theoretical predictions allows an in-depth interpretation of the salient spectral features in terms of Coulomb mixing of "dark" with "bright" final states leading to an effective two-electron one-photon transition. The present work illustrates that the improved spectral resolution of RIXS spectra achievable today may call for more advanced theories than what has been used in the past.