Maybe the problem is that you're considering Nimrod in isolation from the rest of the Enigma Variations? It's merely the 9th of 14 parts, after all. The final variation is quite climactic.
In any case, I don't feel the same as you about Nimrod - it's a pretty much perfectly conceived piece in my book. Doesn't affect me like the cello concerto, but then very little does.