yes, I'm sure that the resources have to be in the same village(tested it myself in the past and tech team confirmed it). Crop is also counted for this achievement but you are right that it cannot be completed in a non WW village - In order to reach storage capacity of 10M in a single village/city, Great warehouses and granaries are a must.
Thank you for the clarification. Then this achievement is the most difficult to get so far. But seriously, village can be transferable if ppl work for achievement only. Would someone crazy enough to build such WW village 'for sale' to get achievement only?