Yes, if you make the pixels smaller, the sensor will get less light sensitive. But for most applications, the sensor size is given (e.g. 35mm cameras) and smaller process sizes would mean, that more of the per-pixel area is taken for light recording and less for the electronic elements on each pixel.