Whereas Amazon has a huge warehouse / fulfillment footprint, Home Depot uses stores + a few (2?) online-specific fulfilment warehouses.
The benefit of that system has been really efficient storage costs. The limitation has been multi-item (especially rarer) pulling from multiple stores (because each only has a few pieces).
At a high level, Home Depot's logistics goal is zero warehoused inventory. Either something is (a) on a ship, (b) in transit to a store, or (c) in a store.
Home Depot has been around since 1978.
Retooling a brick and mortar logistics system into a flow-through, multi-channel one isn't simple, cheap, or easy. But they've been working on it since ~2010(?).
Suffice to say... looking at retail is like looking at the tip of an iceberg. Most of the company (the logistics), you never see.
Unfortunately, Home Depot probably wouldn't be interested. They're doing their thing, have their own extremely efficient behind-the-scenes logistics system, and largely specialize in markets that Amazon isn't interested in. (Some consumer overlap, but Home Depot's bread and butter is non-consumer stuff)
Costco... what would be in it for them? Do they want to move more items / have more members? I guess so? Not sure if they're volume constrained and what their logistics flows look like.
But store-picked + shipper-delivered seems interesting. Costco assembles orders overnight, then truck stops by in morning on way to deliveries and loads. Customers get next day delivery within range of a Costco.