Linda Ann’s Answer
Since you mention neuroscience, you need to have a good grounding in biological functions. So when you say you aren't "good at science" that could mean physics or chemistry or geology... If you've been good with biological concepts AND have a good memory AND attention to detail, you should be ok to pursue the discipline of psychology, IF it doesn't work out while in college after your first year, you can always switch to another major.
Don't sell yourself short without first trying!!