Is there a specific word or name that refers to someone who studies a lot but is not intelligent
Such a person might be called a grind:-
Informal A student who works or studies excessively.
[American Heritage Dictionary via The Free Dictionary].
This doesn't invariably mean someone not particularly bright, but it carries that implication (they are grinding facts into their head, mechanically and without inspiration).
"Book Smart" ~ having a lot of academic knowledge learned from books and studying, but not necessarily knowing much about people and living in the real world