The current shard key error message could be misleading. This error message can be read as the value type of the field is a numeric type and that you cannot use descending order when the field type is numerical. Specifically, the confusion could potentially arise from calling it a numeric field.
As part of this ticket, we should repurpose the message to report the currently allowed shard keys (reported here).