I flew to Hartfort, CT (BDL, actually in the rather distant suburb of Windsor Locks CT) last year, and my flight was delayed to about 10:30pm; I almost didn't get an Uber because the market simply doesn't for the drivers to stick around that late. There were other delayed flights coming in after mine, closer to midnight; my driver said quite plainly that those folks would have to figure something else out, because all the rideshare drivers in the parking lot were heading home for the night.
All this to say, I should have prepared better and I don't know what I expected. We take the "always on" nature of these services for granted, but that's not how the world works outside of the major metros.