Don't be fooled by the $23k range brackets next to a single bracket lumping in everything $527k+. That bracket is just an aggregation of the same chart trajectory, not another mode.
I can't believe this needs to be said, but the salary data that you're linking to excludes the thousands of Bay Area employers who aren't part of levels.fyi's dataset. Most of the employers in their dataset compete with each other, and pay in the second/higher bimodal curve.
This is correct. This also excludes contractors, which there are tons of in the Bay Area, and they make a lot less than a regular employee, even at places like Google.