Unlike electric cars, the price for a used F-150 lightning is still a substantial fraction of new price. There is still substantial demand.
Work trucks are a very different market than for passenger vehicles. Their usage is a lot more consistent and known. This means that electric works very well for some work trucks and very poorly for others.
The other aspect of work trucks is that they're generally purchased by very conservative businesses who don't want to buy the bleeding edge, they want several years of reliability data before committing. The F-150 Lightning was cancelled just as that data was starting to come in.
Of course, most F-150's are sold as passenger vehicles rather than work trucks. Along with almost all Cybertrucks.