Terry Ahern, Pamela's longtime friend and former rep, tells PEOPLE she was "over the moon" about becoming a grandmother the last time he spoke to her