No new add-ons will be released for TSW2, but if a DLC has the "Train Sim World Compatible" logo on it, then yes. However, you will have to buy them from the TSW3 page. You do not need to buy TSW3, but the DLC have been moved there. This will allow you to be entitled to them in TSW3 should you ever choose to buy it.
If you buy any TSW2 compatible DLC on PS store you basically get 4 versions: TSW2 PS4 TSW2 PS5 TSW3 PS4 TSW3 PS5 So the DLC will be unlocked for all of those and you can play it on whatever version of the game you want. That applies to all DLC from before Sept 6 2022. Anything new after this point (including Kassel Wurzburg, Cajon, southeast expanded) work on TSW3 only.
for your information I finished the Tsw2 game already with the tsw3 in use. I bought paea tsw2 and then I had it for free for tsw3. I also advise you to buy for tsw2 because it works for both games, while buying for tsw3 it only works for that one.