How to avoid implicit conversion when using XQuery value() method in TSQL?
You can ignore the implicit conversion warnings, they are irrelevant here.  But parsing XML is not free, and you're doing it the best way possible in TSQL.
If you really need to improve the XML parsing, you'd have to try SQLCLR and the low-level XmlReader, or a pre-compiled XmlSerializer.