Is aviation security mostly for show?

Last week's attempted terror attack on an airplane heading from Amsterdam to Detroit has given rise to a bunch of familiar questions.
Is aviation security mostly for show?