Gravitational waveforms for compact binaries from second-order self-force theory