We do know that LSD affects brain connectivity/activity in a way that you absolutely can make new insights. It's not magic, but sometimes you just need the right kind of push to realize certain things. One of the reasons there's research into psilocybin therapy nowadays.