Does anyone know any long term effects or problems from having a sacral dimple?

Pilonidal disease. A lot depends on the depth of the dimple and how hairy the person is when they grow up. A deep sacral dimple may predispose to pilonidal disease which is a painful cyst or mass under the skin covering the tailbone. They tend to get infected and may require surgical removal.