(Sparrow hanged up while broadcasting the tx and upon restarting it just shows balance 0 and no txs)

If you still have the string representing that tx, try using an alternative method like mempool.space to broadcast it.