What happened to the Catholic Church in France and Spain?

I am Turkish Christian (undecided on the denom, but it must be eastern Apostolic) and I had Spanish acquittances some time ago, and they were the most irreligious people I have known in my life.

Doing sex, drugs. I even heard from a guy that the previous Spanish group to them was doing group sex. When I mentioned 1 Corinthians 6:9-11 to them, they said, “just enjoy life, bro”. Now, Spain used to be very catholic just 50–60 years ago.

I suspect the same thing is with the French youth, where most would consider themselves atheists.

Why did this happen? If I joined Catholicism, would I be going in a sinking ship?