Imagine having middle endian values in a processor. You're reading "1,337" as 3317.
It's nonsensical.
Big-endian yyyy-mm-dd is the most rationally consistent since it's how we write numbers normally. 1,337 is big endian: the 1 is the most significant (biggest) number, etc.