You must understand that Germany - while much smaller in terms of size and population when compared to the US - is still a large country with 80+ million people, so overall the situation is complex. There is a big difference between the north(east) and south: You have a largely protestant, more liberal north and a mostly Catholic, more conservative south. In some ways, you could call Bavaria in Southern Germany the “German Texas”.
So in some (more rural) areas in the South, religion still plays a major role. Many of those areas are predominantly Catholic.
Another large difference: We don´t have Evangelicals or Pentecostals. Ok, they do exist, but they do not play any role whatsoever. Protestantism on any larger scale is done for in Germany. Like completely dead, it is plain miserable, they are the ones really coming apart.
The Catholic church (similar with Eastern Orthodox) has a much better perspective, mostly due to immigration from Eastern Europe (Poland, Romania,…) . So there is some influx of young families which may help in the next decades to prevent the total breakdown. We have lots of Polish priests, I am very thankful for that, without them large areas would no longer have a reachable Sunday mass.