When will we get a vinyl record emoji?

Apple is not responsible for emojis, the Unicode Consortium is.

You can submit ideas here -

https://unicode.org/emoji/proposals.html

Or buy an iPhone with Apple Intelligence and use Genmoji to create your own emojis. You could then save it as a Sticker to use anytime you want to use a vinyl record emoji.

Otherwise, do as Kurtosis12 suggests and contact the Unicode Consortium.