Q: Firmware update failed / my module has a broken firmware. Is it dead?

No, just apply 3.3v to B (Boot0) pad in order to put the module in factory bootloader mode, then update the firmware again.