You could say this about every form of recreation, let alone competitive activity. You don't find it interesting, that's okay, different people enjoy different things.
The best spelling bee champs (the ones winning the big scholarships) are not just memorization machines, they have deep understanding of the etymology and structure of English words (which I happen to find very interesting).
If you set aside a few minutes to watch the Scripps spelling bee, you'll notice that the competitors ask about the etymology and usage of the word in a sentence. This information gives subtle clues (such as Greek or Latin roots) that a good speller can use to spell a word they've never seen before. That is an impressive feat, if you ask me!
I get that it can be interesting to some people but the scale of the whole thing (in the US) is what surprises me every time.
Then again, I also don't get reality TV or pageants. Maybe I'm not the target audience...
At the same time, being able to spell obscure words doesn't have a wide application like being able to run, cycle, drive or swim fast has. (but those probably have their limits as well - fast cycling/running is handy when you also want to be a bike courier or need to outrun a bear, but less useful when you have a day job as a painter).
I guess in the end the point I made also works against my instinct to express a dislike for arbitrary contest when I don't get the scale/following.
Having said that, being able to spell obscure words is likely to increase your vocabulary, which may be useful if you decide to become a writer. Frankly, that's probably more useful than learning how to throw horseshoes.
I think it's less about the act and more about the competitors. You never really see spelling bees among 30+ or even 20+ contestants - because at that age nobody cares. But for teenagers or elementary schoolers, being able to demonstrate an above-excellent level of English comprehension is impressive precisely because of their lack of experience.
This isn't too different from quiz shows, I guess, although information from those tend to be more applicable.
It's also probably a bit of an oversimplification to call it memorizing a dictionary, some of the learning strategy involves understanding the rules of multiple languages, their root words, word etymologies, etc.
Most competitions (why is it a spelling bee and not a spelling competition?) seem to revolve around a specific skill that stands on its own, and it's rarely about retaining facts that are described in a book. Compared to a physical sport, it's as if you'd remember all the rules but then not play the game. Or compared to a sport like Go or Chess, there is no interaction with an opponent, there is no improvisation or strategy, just data.
Maybe it's an American thing, and it holds it's value because it's a tradition that was recently created (well, relatively recent). It's what most searches seem to suggest... (as well as it being the reason that I don't run in to a 'bee' in other countries)