Umm... no?
The truth of the matter, if it can be summed up in one sentence, is that Honda sunk a boatload of money into making new platforms for EVs and facilities to make them, creating thousands of jobs for Americans, in a business environment that encouraged exactly that, with Sony deciding that this made a good partner to produce the EV it was planning, only for a sudden, rapid, and unpredictable series of arbitrary and chaotic changes (even on a day to day basis) that included not only disincentivising the development of EVs but introduced punitive tariffs even for vehicles built in the USA if any component came from outside the USA, which changed the business environment entirely and inserted complete uncertainty (anathema to car companies which plan at least eight years ahead) due to the unpredictable whims of the individual making these edicts, resulting in Honda deciding it was better to take a $16bn hit, recording its first loss in 70 years, and not bother any more with all these new jobs for Americans, while also taking the platform out from underneath Afeela entirely.
It's a big sentence, and also skips out the influence of low-cost Chinese EVs in the Asian market, but it covers the bases. If you want a snappier one: Sony want make car, pick Honda make car, Honda spend lots money make several cars, lunatic crap all over everything, Honda run away, Sony no have car.
And Series 0 could use NMCA battery packs too; lithium technologies weren't entirely required.
Also Afeela was grossly overpriced and already outdated, so wouldn't have been a commercial success regardless.