There is a big difference between what an "executive" does at a 5,000-person company versus a 500-person company, and the latter (or even smaller, frankly) is where fractional leadership really makes the most sense. There are so many early-growth startups that could really use experienced leaders but don't have the funding and/or the track record to attract the kind of people they need on a full-time basis.
Disclaimer: this is a big part of what I do for a living so I do have some intrinsic bias toward it.