I've never driven an automatic car, so I don't speak from experience, but ...
Surely a one-size-fits-all automatic transmissions for bikes would fail because, unlike cars, the engines are all different and have different optimum revs (cadence). So one person might find the bike under-geared and another might find it over-geared. So you'd need an adjustment - let's call it a gear lever.
As to why automatic transmissions have failed in the past, the Deal Drive was very heavy, complex and expensive. I don't know the actual commercial reasons for its failure but I'm guessing that weight cost and possibly production problems were involved.