Amount of books sold and movies made doesn't make him one of the greatest authors alive. Harry Potter sold well too and tbh they're kinda mediocre books now that I'm an adult. Also by your metric the Twilight series is one of the greatest book series ever made.

All of those are books for kids, maybe young adults, and those demographics don't really have the greatest taste in art.