No, strength doesn't imply tension. Quite the contrary, strength actually relaxes you. A strong man doesn't have to strain quite as much as a weak man to perform heavy tasks. His strength enables him to do it easily.

But strength can only come from applying power. On the guitar, this means fretting the notes strongly initially. As you gain strength, you can relax the grip and it'll still feel strong and secure.