I mean, I'd agree. Most people do not operate at scale, and prematurely optimizing for a scale that most people will never reach is a bad idea.
However if we're talking about Wikipedia, any scaling concerns at all basically make it a non-starter.
The advantage of SMW imho is still that it brings the semantic / structured data features right into the MediaWiki itself and that there's a big ecosystem of related extensions around it (like Page Forms). So far I don't know of an open-source information management system which comes close in capability to this. Setting this all up and maintaining it is difficult, though - I even had to start developing custom tools to assist me with that once it got more complex.