I think I'd be most concerned about your hatred for science, honestly. Nursing IS science. The medical field IS science. After you get into NS, you don't start studying film and poetry.
But many people who don't enjoy things like chemistry or botany find they enjoy human-related courses, so I wouldn't move forward with a negative attitude.
The issue of 4 years is kind of misleading. Most ADN programs are ~75 credits which is 5 semesters IF you were to take 15 credits at a time. Some people who are in a hurry DO take their prereqs quickly in about a calendar year, but many don't. How long you take is up to you.
Once you've taken ~30/75 credits and are accepted into your ADN program, you only have around ~45 credits left to take, but you have to follow the semester sequence, so you do not take a full schedule of classes, but it's still spread out over 2 years. My first semester consists of around 8 credits.
So, yes, it takes a bit longer, but you leave prepared to start an important caterer. Not many people can say that after a few years au community college. You can get an AA much more quickly, but good luck with your job hunt.
For a BSN, my program has an early acceptance program with a couple 4 year universities, so as soon as I graduate, I start the BSN program and can finish it in 2 semesters. If you want to start your BSN program as soon as possible, I recommend you either skip the ADN and do a BSN to begin with, or take the BSN prereqs while you're taking your ADN prereqs.
I know the feeling of being overwhelmed - my choice of hiding spot is Fiji, not the forest, but to each his own
. Just take one step at a time. Figure out your first semester and go for it with the best attitude you can. If you hate it, Plan B, something with no science.