However, for your question, the I9 is interesting if you really need it as a professional in video and reporting. Otherwise, to have so many extra cores and use 5% of them means that the price of your CPU is more than 500 euros!
And don't forget that the 14900 consumes a lot of electricity and heats up a lot, so expect your electricity bills to be much higher and make sure you have a good CPU cooler!

Don't look at the description, they've got it 100% wrong, they've put in the description of another motherboard. If you want to know everything about your Hero motherboard, and to know what is compatible, to know which hard drive, memory, cpu etc... Look directly on the Asus site, you have all the manuals and software updates (like the bios).
https://rog.asus.com/us...

I'm replying to you just now, as I'll soon be watching it for Black Fraday.

Yes, it has the LGA 1700 socket that the 9-14900k requires. But only with water cooling!