The type of heating is not economical with deep drilling, no matter where. Air-to-water heat pumps are always more economical in Germany.
Air-to-water heat pumps have other disadvantages, which personally don't bother me.
The statement is only true if subsidies are not taken into account. Air-to-water heat pumps initially cost quite similar to ground source heat pumps. With the ground source heat pump, the source is added... with a €5,000 subsidy (which we, for example, received) a lot is already possible... Our neighbors paid about €8,800 for the drilling (and a €5,500 subsidy), so minus the subsidy that's €3,300. It doesn't take that long for this amount to pay off.
We, of course, are an extreme example with a trench collector, having paid under €2,500 for material + excavator + excavator operator (€1,500 material, i.e., brine pipe, distributor, antifreeze, house entry, cable ties, and €960 for the excavation work). About 4 days of own work by me (and 1 day of 5 hours laying by an additional friend, paid with beer and steak) are of course added (roughly 2 complete days planning the collector including reading up and ordering the material, 2 days supervising the excavator and laying). It was a fun project and even paid off directly with the €5,000 subsidy, as it was cheaper than the air-to-water heat pump after deducting the subsidy. However, the main reason was not financial; we just didn't want such an ugly device standing on the house, and as for exhaust air heat pumps, which are completely inside, I am really not a fan at all.