first of all, school privileges Ti above all other functions. but it doesn't matter if your communication skills can't make it work.
i sympathize with all N types who don't get any N teachers in high school. you don't realize what a fucking revelation it is when your teachers get what you mean, who can't lead you from what you mean to what you actually want to say. infjs, for instance, are often extremely vague when trying to communicate what they see- it's a common critique of infj writing. i repeatedly got great writing scores in all categories except "substantiation," in which they'd give me 8/15 and say that they had no idea why or how i was trying to answer the question/what i was even trying to talk about. i don't really see a point to anything intellectual until i had a great entp instructor in an advanced english course senior year.
college is better. you have to explore to figure out where you fit and how to make use of your skills. for those who have intense financial pressures and need to get a well-paying job, well, again i sympathize. sometimes these things overrule learning. but for others who get to play around in different disciplines, problematics, discourses, etc, there are plenty of spaces that are N-friendly. anthropology, sociological theory, rhetoric, literary studies can easily work, religion, most of the social sciences and humanities, etc. i see a lot of N types in biochem, physics, and other more imagination-friendly hard sciences, that requires layers, more complex modeling, etc. don't do something that emphasizes rote memorization, and be wary of classes with god-awful textbooks. i'm pretty sure NTs rule finance as well.
one useful thing to keep in mind is that constructing positive relationships with fellow students and faculty give you an enormously useful support when trying to find your way through the university/academic world. they've learned a lot of shit on their own, sometimes it makes more sense to absorb more guidance from others rather than demanding that you figure it out all on your own.
i also think that especially highly highly introverted in types, especially those with /sp high up in their enneagram stacking, are often put off by the exhaustion of dealing with others. i know as an sx/sp type, i have a tendency to get REALLY frustrated when i feel like discussion/curriculum/studies etc are going in the wrong direction, and i generally have a conflict with groups who i deem irrational, misinformed, and full of too easily influenced mass-mentality wasted talent. too much conformity, not enough authentic searching, wandering, self-sustaining meaning. but this is on me to figure out rather than on groups to not behave- like groups.