‘In the last few years, it seems as if America is split in half,’ says the producer of Pink Floyd’s The Wall and Lou Reed’s Berlin