That's right, the primary distinction is to the types of targets each is intended for, though generally speaking tactical nukes are lower-yield than strategic ones. (Because if you're aiming a nuke at enemy forces on a battlefield, the odds are pretty good that there are friendly forces a short distance away on the same field that you'd rather not kill at the same time.)