Correct (IAAL*). He has suffered no legally cognizable injury or adverse effect (nor even a plausible connection to harm). So no standing.
Also, there is no legal theory under which he has a cause of action. In order for there to have been a tort, the defendants must have owed this guy a duty, then breached that duty, and that breach must've been the factual and proximate cause of actual harm. But Joe Random USA was an unknown, unforeseeable, causally unconnected nonparty who suffered no harm. Snowden et al owed him no duty, certainly not a fiduciary one.** So no tort.
What about his quasicontract theory of unjust enrichment? Maybe he's taking the term too literally. It's not simply that someone was enriched and you find it unjust. It's that you had a real or implied contract with the other party and they benefitted to your detriment. Did this guy half finish building Snowden a deck and then not get paid? No? Then he can't sue for unjust enrichment. Similarly, he couldn't, as a random citizen, sue on my behalf if I was the one who built the deck for Snowden. Nor could he sue North Korea for "unjustly enriching" themselves at Sony's expense.
*I am not your lawyer and this is not legal advice.
**Snowden may have owed the US govt a fiduciary duty, or duty of confidentiality or loyalty. But despite this guy being a retired naval officer, he is not the US govt.