It is the majority of my classmates' aspirations, yes. It is not necessarily mine. You have to understand that 80% of school psychs work in schools so the majority you will meet probably WILL want to do that. However, yours is totally a valid option, and one I am considering myself (pediatric neuropsychology) it may even be refreshing for some admissions committees to hear! However, I would be careful which schools you reveal that to.... Certain SP programs are just around to train academics so they may be wary of someone who has a different path. I would say generally it is a good idea to know what kind of career the schools you are applying to are training for, but that overall it should be totally fine to mention that being your career goal. I would NOT mention that you don't like working in schools, as probably the majority of your practicums will be done there. I would just say that you are intrigued by the prospect of checking out other applications of SP.
Are you applying to PhD programs? Which ones?