Elon Musk's widely derided Tesla Cybertruck now stands alone as the biggest flop in automotive history, according to experts.