I get the impression that often when some ancient thing or place is described as having a 'ceremonial' significance, that they really mean to say "we have no idea what it's for".
You are correct. But more than that, how about when they say "religious significance?" That also seems to explain away the "we have no idea what it's for." When "religious significance" is used, folks appear to be intimidated to disagree (or laugh).