Thinking about majoring in Geology

During this semester at my community college I took a historical geology course and I enjoyed it thoroughly. I barley understood what was going on at the beginning, however throughout the course I was getting better at understanding everything. I continued to enjoy the course all the way through. Before the historical geology course I took a Physical Geology course and I enjoyed that as well.

During the historical geology class we had to do a project that entailed all of the Epochs withing the geological timeline. While looking up everything about the geological timeline I learned a lot and it made me think that that's what I want to do, I want to learn more about geology.

in my physical geology class I did not do so well in the class despite it being a 100 level class. I enjoyed geology a lot but this discouraged me from getting into it, I also "failed" a simple test when I applied for a factory. To me that sort of thing happening meant that I should not get into the education field, or the science field at all.

I want to major in geology however it's discouraging whenever you get bad grades and when you do not understand the material. I think to myself "if I can't understand this how do i expect to get my BA or even Masters in geology." I eventually want to overcome my academic struggles to find out what I want to do, but it's really hard when you are constantly doubting yourself.