It seems that the majority of suggestions (and that is what they are at this point, suggestions) to fix this is to use a trusted mechanism which defeats the whole purpose of P2P. Hello, folks, this is not DigiCash and we are not going to bring DigiCash back. I think we should be pretty clear about this: NO TRUSTED NODES. If we install trusted nodes, that will be exactly what the Schumers will go after to shut the network down.
You don't need to trust anyone to run a lightweight p2p node.
A lightweight node is one that only keep block headers.
Currently, the single implementation of light p2p node I'm aware of is BitcoinJ. And this implementation still downloads every block content IIRC, to check if you have a tx in it. It only stores the headers. This will be a problem once downloading blocks requires more bandwidth than what an average user can have, but we're still far from that (the problem with the main client is inserting the data in the database, not downloading it). And people are already working on implementing Bloom filters that would allow lightweight clients to only query the transaction set that interests them, and still be able to be sure it's valid due to the Merkle root in the block headers.
Those who should worry with scalability are those who must use a full node: pool operators, solo miners and miners in P2Pool. They'll be paid for it, though.
I saw some forum post claiming the bible considered this problem and described how to address it, but I just re-read the bible again and there is no such solution, unless you are referring to the idea of transaction pruning to headers. Transaction pruning will do nothing. It is an arithmetic order solution to an exponentially increasing problem. If you were to implement some elaborate pruning scheme, you would not even notice the difference.
Pruning might help those who need a full client, but yeah, I agree with your feeling, it's probably not that relevant. At least I believe their main issue will be bandwidth not storage.