This leaves out a very important piece of the equation. Perhaps the most important piece.
Even in places like New York and California that are rapidly turning YIMBYer, prefab and manufactured housing is being frozen out. The reason is that the construction industry, and (especially in blue states) construction industry unions, are very very powerful and wage total war on legislation and politicians friendly to prefab housing because it completely cuts them out of the process.
The state-level politics are so toxic for this reason that it's unworkable to get stupid bans undone. This dynamic is, frankly, a lot more intractable than the obstacles this article discusses: you can convince regular people that mobile homes are worth it even if they're ugly, but you can't convince construction industry people not to put their own interests first.