The piston pushes the boat, but the zombie floats out. Solution: The 1.21.30 patch changed boat collision. You need to place a block of honey on the wall facing the piston. Honey blocks prevent mobs from dismounting boats during redstone events.

Here is a guide explaining the context, the "patched" exploit, and the current legitimate method to obtain this type of achievement.