If anything in the last 32 plus years, I would say that we have seen the introduction of quite a few diesel trains since the introduction of the class 165 units in 1991.
The issue you have is how to be replacing the class 150, 153, 156, 158 and 159 units, plus within the next 10 years the class 165/166 units. Here lies the issue. If these are not replaced, then we do not have enough to get us to the point of decarbonisation. That having been said, the year for decarbonisation is forever changing depending on who you talk too. Some say that it should 2040, some 2050 and others 2060.
The likes of HST, MK3 and Mk4 coaches have pretty much been replaced by class 180, 220, 221, 222, 800, 802 etc...... But there is uncertainty as to whether the TOC's need to be keeping the amount of units that they have in their fleets currently. Which may mean newer diesel fleets get scrapped as well.
For Scotland, yes. The Scottish decarbonisation plan requires no diesel trains beyond what is already in service
For England and Wales, it will mostly depend on how fast new electrification gets deployed. At current rates, I don't think existing DMU are enough. If however, electrification gets sped up significantly, as is really necessary, combined with some strategic deployment of battery EMUs, we could even end up scrapping some of the most recent DMUs before their 40th birthday.
I think even Scotland may need more diesel trains than they currently have or those to be replaced by bi or tri-mode trains as per my comment below. Specifically, I am think of the class 156, 158 and the HST Inter7City trains. Otherwise you will be having no trains to Dundee or Aberdeen.
As commented by eldomtom2, any future trains should be bi or tri-mode trains where possible to replace class 150, 156, 158 and 159 units. If it is bi-mode than it should be battery/electric power, rather than including diesel in any form. Diesel should be included if the distance being covered is such that it is took long for a battery or Hydrogen to keep the train going.
A good example is the class 170 units used by Cross Country on the Cardiff to Nottingham services. If we start off at Cardiff, you have OHLE from there to Severn Tunnel junction at which point, it should be battery power all the way to Bromsgrove, where we can use OHLE. The issue that you have though between Bromsgrove and Birmingham New Street, is where it is four tracks, the fast tracks do not have overhead electrification.
If electrification was across all tracks between Bromsgrove to Birmingham New Street, then you would have enough charge in the batteries I would suspect to get you from Birmingham New Street to Nottingham and return back again to Birmingham New Street.