Yeah, it will sometimes reveal invisible pathways (say, over bottomless pits) and any secret combos that are triggered by burning, bombing, etc. something else. It may not always reveal secret stairs, caves, or bombable walls, though (although the lens will reveal some of them).

Oh, and you might want to try tapping the button instead of holding it down. This can help conserve your rupee supply.