Speech Translation with Speech Foundation Models and Large Language Models: What is There and What is Missing?