PLEASE let him keep a light on. This is something he needs and there is no reason to withhold it. He may outgrow it and he may not, but so what. Have you tried a 40 watt bulb? GE makes a "Softwhite 40". It is a CFL (compact flourescent) and has 8,000 life hrs. and is very inexpensive to use, pennies for 10 hrs. Second, depending on the lampshade, you will have more or less of a glow. A translucent shade will be brighter than a black shade.
Third, as far as YOU seeing the glow, if you have not already, try different locations in the room so it impacts you less. If you have trouble finding this bulb (and you really should not) email back and I can locate a source for you (inclucd the area where you would shop) Also, it does not HAVE to be a CFL, although that is more ecofriendly. You could just get a regular 40 watt softwhite. After a month or so you could quietly switch to a 25 watt, but if he notices, go back to the 40.