Elon Musk has said running Twitter has been "quite painful" and "a rollercoaster", in a last-minute interview with the BBC.