One example: Between Amsterdam & Bern - Skybus flies for €86 (1.5 hours) and the CityNightLine train is €80 for a bed (11.5 hours). Other routes are comparable, you can pay a bit more for your own (non-shared) compartment.
Economically it seems crazy to take these night trains, and I never even bothered until a recent business trip from Amsterdam to Munich.
It was great for many of the reasons mentioned in the article and other comments here: leave and arrive in the city center, no security, no gate closing time, no baggage restrictions/pick-up/lost luggage, have a beer or dinner on board at a real bar or table, use your laptop/phone/ereader whenever you like, lie down, take a shower, whatever. Basically it's like flying the night before with a free (albeit basic) hotel stay thrown in.
I'm worried that too many people dismiss the night trains too easily (like I did), and that these will be relegated to the history books. In my opinion that would really be a tragedy.
Plane travel has turned into a elementary school bus trip. The train is still a grown-up alternative.