Sophie Ellis-Bextor recalls the “horrible” failure she experienced in her career