Yeah I see... so should I also cancel the last try to send it to the wallet as it won't get confirmed either?
I thought if I cancel it, I can resend it immediately :/
You don't need to cancel your last try because it wasn't even accepted by the network at all.
Just remove it out of Bitcoin Core with zapwallettx or similar.
No, you can't 'cancel' transactions once they are broadcasted, the only thing that works is waiting until they're removed from the mempools of the majority of nodes in the network.