Next to FSX repaints I still do FS2004 repaints as well. I'm currently working on a highly detailed paintkit for a payware FSX model. And there are still some Bf109 Friederichs for FS2004 in the paintshop, I'm planning a few repaints for Wozza's P-51 (FS2004) and I still want to do a HD paintkit for the Restauravia Bloch Mb151.
(More plans than spare time actually)
So for me FS2004 is definitely not dead yet. But as there is far more available already for FS9 (both aircraft as scenery) than for FSX there is less to develop, therefore there are also less developments to discuss. People like Uncle Milton, Manuele Villa, A.F. Scrub, Dave Molyneux, etc. are still creating models for FS2004. So yhere is enough and still enough to look forward to.
BTW I have a hangar full with FS9 repaints which I never uploaded. Some examples:

At least 3 Macchi MC.200 liveries for Mr Ito's model

At least 5 different Fiat G.55 liveries

2 bf109 Friederich liveries for the Flight replicas model

2 liveries for Mr Ito's Fokker G.1

Next to that at least 5 liveries for BrunoSK's CFS2 Spitfire (which works in FS9 as well with some work).
But you should also be realistic. FS2004 is over 10 years old. Logically the number of people who stop flying in FS2004 is larger than the number of people who will start to fly in FS2004.
Cheers,
Huub