Is it possible for an Alternate Payee to lose his/her rights to the pension?

Yes. If the participant dies before the QDRO is finished and approved by the Plan, the alternate payee runs a substantial risk of losing his/her interest in the pension.