The theory behind antagonist superset is sound. However it is hard to apply successfully on legs when it comes to compound movements. The reason is that during a movement like a squat, all the lower body muscles are involved (quads, hams, glutes, calves to some extent) and even the RDL, which is primarily a posterior chain exercise hit the quads some (mostly isometrically to hold the position).
So the RDL would decrease squatting (or front squatting) performance by fatiguing the hamstings/glutes to a significant extent and the quads to some degree. They would also fatigue the lower back which would make it harder to keep an upright position in the squat.
That having been said, the front squat will not have too much of a negative impact on the RDL (the back squat would). So doing front squats then RDL would work. But I would then take ample rest before going back to the front squat, to avoid a negative impact.