I just purchased this exact model a few days ago as well. Everything you described happened exactly the same way. Tried to update firmware, failed, disappeared after second attempt.
I didn’t have time to screw around with it so I shut my system down and have not been back to it yet.
I would really like some clarification/help from Corsair. I installed this per the installation instructions.
Did you figure anything out?