Dynamics-Compliant Trajectory Diffusion for Super-Nominal Payload Manipulation