[Java and Kotlin] Topics and queues scenario for these languages is in the wrong metadata file and uses the wrong format

[Laren-AWS]

Two work items:

• Move the metadata for the Java and Kotlin SNS/SQS topics and queues workflow out of cross_metadata.yaml and into sqs_metadata.yaml with the rest of the languages.
• Update the metadata for these two languages to use code excerpts through snippet tags instead of an XML block.

[meyertst-aws]

There is already an issue for this. #5071