My watch-only Electrum wallet still has it pending in transactions history.
When, and how, will I know that those coins are again in my sending address and I'm able to spend them in another transaction?
It will take a little while for the miners to drop the transaction from their mempools. When it does, it should stop being pending in your wallet.
There's always the chance it will go through still, of course.