[@aws-cdk/aws-secretsmanager] ARN is incorrect when getting via fromSecretName

[arpowers]

When using fromSecretName with secrets manager, it returns a secret but the arn property is returned as the name of the secret (used for lookup) not the actual ARN.

Reproduction Steps

const theSecret = secretsmanager.Secret.fromSecretName(
      this,
      "TheSecret",
      "my-secret-name",
    )

return [theSecret.secretArn]

// returns  ["my-secret-name"] should be [<the arn of the secret>]
--- 

This is :bug: Bug Report

[njlynch]

Duplicate of #10519. PR to fix is #11042.

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.