No, it is actually very rare. With proper handling by experienced adoption lawyers, the risk of such a dramatic reversal is rather minimal.