Does the special offer also apply to tickets for local transport?

No, the special offer is not available for local transport tickets (e.g. transport association offers or the standard fare of the Deutschlandtarif). It is only available for long-distance tickets within Germany, provided that at least one section of the journey is on an ICE or IC/EC train.