He absolutely did not envision Bitcoin being used in a mainstream way for everyday transactions, and the technical architecture of blockchain makes that impossible.
The current system where every user is a network node is not the intended configuration for large scale. That would be like every Usenet user runs their own NNTP server. The design supports letting users just be users. The more burden it is to run a node, the fewer nodes there will be. Those few nodes will be big server farms. The rest will be client nodes that only do transactions and don't generate.
See? He used even those words: "large scale". And also "big server farms". If he didn't think about mainstream, why he used words like that?
Satoshi never meant to Bitcoin to be used by "everybody", or even a "lot" of people: the problem Bitcoin (and blockchain generally) solves is an extremely narrow one.
Simplified Payment Verification is for lightweight client-only users who only do transactions and don't generate and don't participate in the node network. They wouldn't need to download blocks, just the hash chain, which is currently about 2MB and very quick to verify (less than a second to verify the whole chain). If the network becomes very large, like over 100,000 nodes, this is what we'll use to allow common users to do transactions without being full blown nodes. At that stage, most users should start running client-only software and only the specialist server farms keep running full network nodes, kind of like how the usenet network has consolidated.
So, is it "a lot of people", when you think about "over 100,000 nodes"? And again, there are "the specialist server farms" mentioned.