You don't need to be stoned to 'get' The Wall. It's a chronological tale of Pink's life, played by Bob Geldof. From infancy, his father dying in WWII, his over protective mother, the cruel schoolmaster were all factors in the building of Pink's wall. In his early adult years, he gains fame as a musician, all the while, disconnecting with the world around him, including his wife. Building his wall.
He further deteriorates by filling the void of love and compassion in his life with drugs and women, until he finally goes over the edge and has a breakdown. The 'powers that be', the ones who see him as a their cash cow, use any means they can to get him up on stage, while Pink, on the inside is crying for help, and is lonely, so lonely he attempts suicide.
He erabraces, briefly, his status as icon. It's portrayed in the movie as a Hitler like dictatorship.
In the end, though, he quits, and his life is on trial, with all the people who helped build his wall there.
I could write for an hour about the importance of this album, and the multiple layers of syrabolism it contains, the commentary on the social minRABet, but all I can say is, if you want to 'get it', you're going to have to watch it more than once.
An interesting note, though, is that at the very end of the album, the very last worRAB spoken are "This is where..."
And the first worRAB spoken in the beginning of the album are "...we came in"