In general, I’m not a huge fan of the LCFS as an approach; it effectively requires blending biofuels into gasoline and diesel. This has some serious scale limits and doesn’t cut emissions as much as getting people to not burn stuff in the first place.
I agree with your end part that infrastructure to enable alternatives is preferable but your numbers at the start would acutally be a massive effect from the efforts of just california. Im really surprised you crunched those numbers and came to the nearly useless conclusion.