You probably wouldn't use DIP packages in most modern designs unless it's a low-volume part that you don't mind hand-soldering. However, DIP packages have been used for so long in so many things that the most common DIP ICs are going to continue to be manufactured for a very long time I think.
It would be interesting to know what the statistics are for the global production of various DIP package ICs. Presumably the production of the DIP variants of 555, TL074, and similar ICs peaked at some point and started to decline, but maybe not.
Apparently it's still economical to produce fairly specialized DIP chips, like reproductions of the 3340 [1] voltage controlled oscillator chip used in a lot of synthesizers. Low volume specialty chips tend to be more expensive, though, which I suppose justifies the costs associated with manufacturing.
[1] https://aisynthesis.com/product/alfa-3340-vco-ic/