It's meaningless to compare a small city truck to something like a full-sized truck, they are totally different classes of vehicle. I get that ford doesn't make a small electric vehicle, but that doesn't make the lightning the "closest offering".
>Is there another EV offering that's closer and available in the US?
No, that's the point, it's filling a niche that basically nothing else does right now. The closest alternative would be a small electric car paired with a small utility trailer. Something like a Nissan Leaf and one of those $500 trailers from harbor freight. Which added up and with discounts probably costs fairly similar to this.
A more reasonable comparison is probably the hybrid Maverick, which appears to be popular (at least around here), has 4 doors and actual features, and starts at around $25k.