Even if we assume that's true and say only 50% of owners have actually played the game, 10% for Joan of Arc as the most played campaign is still not "the vast majority of Age2 players are non-competitive campaign players". That might be true if nobody ever finishes a campaign, though, but good luck proving that. I am a big campaign player btw, but I haven't finished any campaigns yet because I get distracted by other games. Soooo, maybe? A friend of mine has sporadically played AoE2 for decades and he has never finished a single campaign, he has only played skirmishes against the AI. Skills in skirmishes don't translate to campaign success btw, he was terrible when I forced him to play Joan of Arc for my amusement.
There's also the problem of current vs former players.
I played all of the AoE2 campaigns, and the AoE3 ones as well. And will no doubt do the same with AoE4.
But I won't appear in any statistic about AoE2 because I'm not playing it anymore.
I'd wager most people still playing that game are long done with the campaign content (if they cared about it at all) and basically only online players remain.
People like myself who prefer SP are simply not part of the community for very long - unless a game offers lots of replayability, but that's not exactly something AoE is known for since it doesn't have a proper sandbox/conquest campaign.
Skirmish alone just doesn't do it for most people.
At the same time, we have the same monetary value for the developer (or more, even, since we don't really cost maintenance of online services) - of course, MTX changes that to an extent.
Analyzing achievements alone doesn't really do much as we don't get information about who plays only SP, who plays only MP and who does both (and to what extent).
I'm sure the developer has such a statistic, but I doubt we'll ever see it...