I can count on one hand the number of Catholics I've met, worked with, and been related to that fit your wishful thinking view of Catholics.
Most of them are leftists and vote democrat and have for decades, if not their whole life. It is simply not true that lay Catholics overall lean right.
On behalf of Catholics everywhere, I apologize that you’ve been forced endure the worst of our brethren in your places of employment. However, your anecdotal experience notwithstanding, polling data supports my point about “Catholics in the pews,” i.e., people who actually participate in the Catholic Church.
“Trump’s favorability among Mass-attending Catholics — those who attend Mass daily or once a week — stands at 67% viewing him very or somewhat favorably. Among Catholic voters who attend Mass a few times a year or once a year, the number is 43.5% for very or somewhat favorable.
He is also buoyed in the polling by a gender gap: 62% of male Catholic voters view him favorably, compared with 45% of female Catholic voters. Catholic women voters also gave the president the strongest unfavorable rating at 33%, compared with 23% for males.
Likewise, Trump is viewed very or somewhat favorably by 58% of white Catholic voters, compared with a still significantly large 41.5% favorability among Latino voters. White and Latino Catholic voters are also nearly identical in viewing Trump very unfavorably, at 27.8% and 28.6%, respectively. “
“Catholic Voters Still Back Trump, EWTN News/RealClear Poll Finds”
https://www.ncregister.com/news/catholic-voters-still-back-trump-ewtn-news-realclear-opinion-research-poll-shows
Obviously if you want to talk about the politics of “Catholics” as everyone who self-identifies as such based on some tribal affiliation or having briefly attended a Catholic school 40 years ago or similar loose connection, then maybe you get a different result.
It is also true regarding Jews. They lean left.
This is the reason that religion and politics don’t mix well.