the stall was effectively unrecoverable
It would have been easily recoverable if the stall horn had worked properly.
It was working properly, which is part of the problem. The captain was not in the cockpit at the time of the first two stall warnings, and only heard the third. One must question, therefore, the procedure to call him back into the cockpit and then, further, to allow him to direct the crew's response.