From Genesis P-Orridge at Pioneer Works to Louise Bourgeois at the Met, our pick of the best exhibitions in the city this week