My competitive public HS has around 2200 students and 4 counselors. They do help when needed, but are often swamped with sophomore meetings (to plan out junior and senior years, where they discourage people from taking too many high-level courses and people take them anyways) and senior stuff (letters, etc.).
However, we have a career center and a career center specialist, which I guess helps. It has stuff relating to majors, colleges, and computers that can access Naviance.
Thankfully, every sophomore is required to meet with their counselor and talk about their plans for the next two years of high school, which includes all of the courses they’ll take, some colleges you’re thinking of applying to, majors, taking the SAT/ACT, etc.