With using zapwallettxes command, you ask your node to remove the unconfirmed transaction, but there is no way to ask other nodes to remove your transaction from their mempool.