No, it only works with a specific list of wonders. The list of wonders for which graphics are avaiable can be found in the readme of the Apolyton Tile File. These wonders aren't mod-specific: they're a list of important Wonders, from all times from all over the world, developed especially for this purpose.
The original game has it's own list of wonders, completely independent from the Apolyton Tile File. Those wonders that are BOTH in the Apolyton Tile File mod AND in the original game will be visible on the map when you build them with the Visible Wonders mod (in this case that is probably only a small number: probably no more than half a dozen).
Once other mods such as Cradle implement Visible Wonders as well (this will take some time), the same situation applies there: only those wonders which appear BOTH in e.g. Cradle AND in the Apolyton Tile File will be visible on the map when they are built. To how many wonders this applies will be different per mod: for the mod I'm working on myself (which is far from finished so don't get too excited
) there will probably 30 odd wonders visible on the map. Most other mods will probably have less, though that depends entirely on what the modmakers themselves want.