You had the meaning right. No one gets "words of wisdom" from marijuana. And Paul is on record saying the inspiration for the song was his mother, Mary.