I realize this is confusing, but the add_kubernetes_metadata processor adds metadata about the pod that heartbeat is running on. Not very useful for your scenario.
Starting in heartbeat 6.7 , when using the heartbeat autodiscovery provider k8s metadata will be added automatically.
Till then, you may want to use a similar approach to Autodiscover and metadata