Does the BahnCard 25 and 50, 2nd class = 1st class special offer also apply to local transport tickets?

No, the promotion does not apply to local transport tickets (e.g. transport association offers or the normal price 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.