However, Rome overall counts and treats such nominal or worse RCs as members in life and in death, even notorious public sinners who would be forbidden to have church funerals by canon law if they would be a scandal to the faithful. Evidently they are not, or the faithful are the majority liberal.
Apparently, there are plenty of nominal Catholics. Generally, the Church let’s the weeds grow along with the wheat. It isn’t the Church’s job to condemn.
But regarding public sinners and scandal, the clergy have been lax for some time.