Toward Reliable Dipole Moments without Single Excitations: The Role of Orbital Rotations and Dynamical Correlation