Major in what interests you. Your major plays no role whatsoever in your ability to get into med school. Nor does our major have any bearing on what your eventual specialty will be. (If you want to be psychiatrist, you’ll learn everything about psychiatry during residency. Nothing you learn in undergrad will help you.)
Neuroscience (like psychology) is a broad field which has many subfields and areas of study.
I’m not sure what clashes of beliefs you’re talking about regarding neuroscience and psychiatry. There’s a ton of overlap between the two and no hostility between practitioners of each discipline. In fact, there is lots of collaboration between the two fields.
I have a strong suggestion for you–don’t choose your major based on a putative future medical specialty. You’ll likely change your mind a half dozen times before you actually have to choose a specialty***. (And that’s assuming you do eventually get into med school–and there are no guarantees on that.) Until you complete your clinical rotations as a 3rd and 4th year med student, you really can’t know what you’re going to end up specializing in.
**There’s data showing that med students change their mind about their eventual specialty an average of 3-4 times during med school. If you want to go back to high school or undergrad-- younger students really don’t have a clue because they haven’t had sufficient exposure to what clinical medicine in various specialties actually entails.