[Resource Type] - [BUG] - AWS::S3Tables::TableBucket incorrect Return value

### Name of the resource

Other

### Resource Name

AWS::S3Tables::TableBucket

### Issue Description

The !Ref for this resource seems to return the ARN of the table bucket, not just the name. The [docs](https://docs.aws.amazon.com/AWSCloudFormation/latest/TemplateReference/aws-resource-s3tables-tablebucket.html#aws-resource-s3tables-tablebucket-return-values) state that:

> _When you pass the logical ID of this resource to the intrinsic Ref function, Ref returns the table bucket name._

which is what I would expect normally.
The only other attribute listed as available with GetAtt is `TableBucketARN` which of course is returning he ARN. Not having access to the name requires splitting of the arn which is annoying.

### Expected Behavior

!Ref returns the name of the s3 table bucket

### Observed Behavior

!Ref returns the ARN instead

### Test Cases

In the output section:
Outputs:
TableBucketName:
Description: S3 Tables Table Bucket Name
Value: !Ref IcebergTableBucket
Export:
Name: my-stack-TableBucketName

Then check the export and see the ARN instead of the name

### Other Details

_No response_

Start with the AWS::S3Tables::TableBucket return-values documentation and reproduce the issue using the provided Outputs template. Compare the exported !Ref value with the documented table bucket name and the GetAtt TableBucketARN value; done means the observed Ref behavior matches the documentation or the discrepancy is documented and addressed.

Written by the indexing model from the issue text.