As I said, it's nothing to do with being inherently silly, as you say, a lot of films are. But the conclusions and premises don't stack up for me. Like, for example, how Gandalf just brings out some random magic whenever they're losing...Why couldn't he have done that before? Why couldn't they have used the eagles more? Why didn't they go straight to the army of the dead? blah blah blah..My unappreciation of it has very little to do with the silly nonsense of it all being about weird magic rings that don't really seem to do anything.
However, I completely agree that it's a hugely significant cultural work. Again, much like Star Wars. It's just not really my cup of tea is all.