Who cares what “the majority” (i.e. poorly catechised) want? People in hell want ice water but they aren’t going to get it.
Rather than being " poorly catechised," I am sure most all RCs know the position of their church on this, but besides being able to ignore it, as even proabortion, prohomosexual Catholic public figures are manifestly considered to be members in life and in death by Rome, then a principle in Catholicism is that leadership defines what she means. Which, as V2 exampled, can mean something different than what was historically taught, as TradCaths here also assert.
Yet besides this, people tend to look for the interpretation of the preachers words but how they translate it in their own lives, as faith is indeed shown by actions. (Ja. 2:18) How much more when "the Church is essentially an unequal society, that is, a society comprising two categories of per sons, the Pastors and the flock...the one duty of the multitude is to allow themselves to be led, and, like a docile flock, to follow the Pastors." (Vehementer Nos, an Encyclical of Pope Pius X, 1906)
Thus, even granting Teddy K, an ecclesiastical funeral, in prima facie contradiction of Canon 915 - with a eulogy by no less than Obama - (besides Teddy receiving a gracious letter from Ratizinger, read at the funeral) in response to his own impenitent one) then the implicit front-page message to the laity is that such violations of RC doctrine are at least tacitly allowed.
Likewise, rather then RC use of contraceptives being due to deficient catechization, they seem to understand CCC 85 ("The task of giving an authentic interpretation of the Word of God, whether in its written form or in the form of Tradition, has been entrusted to the living teaching office of the Church alone") to mean according to how leadership widely applies it, ignoring the likes of Cardinal Burke.