How many non-children fantasy movies are there really that are considered "great movies"?
All I can think of is Conan the Barbarian and Lord of the Rings.
While science fiction has had a number of very successful well regarded movies, fantasy movies are still generally a pretty trashy thing.
It really depends on your definition of fantasy. For example, we tend to use an expansive definition of "science fiction" but, mentally, our image of fantasy movies tends to get stuck on "Sword & Sorcery" (Conan) or "High Fantasy" (LoTR), and there aren't a lot of those.
But fantasy is a fairly expansive genre.
Depending on the exact boundaries, you would need to include Pan's Labyrinth, Wizard of Oz, the Harry Potter Series, the Princess Bride, Mary Poppins, and ... heck, you could probbly put in the Oscar-winning Shape of Water as well!
What about Tim Burton? Edward Scissorhands, Sleepy Hollow, Corpse Bride, Beetlejuice etc.
What about Gilliam? Time Bandits, Baron Munchausen etc.
Then there's the animated - Coraline, some of the output of Miyazaki (Spirited Away etc.), Shrek, Fantasia, Onward, etc.
And then ... what about some of the MCU movies and other superhero movies? Thor and Dr. Strange arguably. The Hellboy movies?