Pop psychodrama Mother Mary might look and sound the part but it’s the latest failed attempt to turn the life of an arena-touring singer into a compelling movie