Nonlinear optical signatures of the tensor order in Cd$_2$Re$_2$O$_7$