Yes, it is very expensive (2 kids here). It's not appreciably more expensive than a Midwest town unless you really want that super premium private school.
Schools in the Bay Area can become pretty poor once you are in a more affordable area. If you want a decent school the rent/mortgage will reflect that.