It was agony and ecstasy for Fremantle as recruit Aisling McCarthy kicked a goal after the siren to give them a thrilling six-point win over Melbourne.