"...with more substantial investment, the site could became a major tourist attraction and pilgrimage destination."
It would become a pilgrimage destination if at least some of the shards could still transmute water into wine (even better if different shards produced different drinks: a martini shard, a "Manhattan" shard and so on). The resulting establishment would be immediately and hugely popular.
At the top of their wine list will be a lovely Shard-O-Nay.