Quantum Molecular Dynamics Driven by Short and Intense Light Pulses: Towards the Limits of the Floquet Picture