ReSpeaker Lite Firmware Upload Messed Up

Yes, you are doing right. Powering off first, holding the BOOT button and then re-connecting the Type C cable to XIAO ESP32S3 is the way to let it start in “boot” mode. Then you will be able to upload esphome firmware to it.