Eric Schmidt almost surely doesn't _need_ ex special forces guys doing his security. He does it because it makes him feel/look important, or he's paranoid, or he may as well because he has the money and the company may pay for it anyway.
There are plenty of super-rich super-famous people in SV who don't have large security entourages and get by just fine.