Skydio seems to be doing just fine, though their customers are more companies that want security rather than consumers.

I think what killed it is the FCC rules, which make it illegal to fly in a large number of places where it really shouldn't have to be. This severely limits the size of the market for a $1,000 gadget.