What you say seems correct. A rope can be under tension, but it can hardly be "tense". "tense" is, as you say, used for muscles, and also more figuratively for people's emotions and for situations generally.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.