Foam is created by the bubbles of carbonation. But the actual foam consists of proteins in the liquid. Cider doesn't have the amount of protein in it that beer does, so it doesn't stay.
I can't answer the actual cost question, but replacing a rod is a big deal. In many applications the engine would need to be removed from the vehicle. The cylinder head and oil pan would need to be...