2014 explorer put in gear makes a heavy clunking noise
This is more likely to be a case of a bad universal joint in the driveshaft, rather than a transmission problem.
If it has the 6 speed auto, that is pretty typical of this transmssion. Annoying, sure but not really a durability issue. But I’d check the U joints just to be sure.
How many miles?