The excitement over the ex-CIA officer accused of spying for China hides a less glamorous truth – that most of Beijing’s ‘foreign agents’ are engaged in work that is banal, costly … and largely pointless