Eastern Rite Catholics have married priests. They're basically Orthodox in communion with Rome.
The majority of Catholics are either liberal-woke or milquetoast and simply just cultural Catholics. Catholics who take their faith seriously are fewer than we like to think online (unless we're in a Traditionalist parish or, at the very least, a traditional-friendly conservative Novus Ordo parish). The future of the Church will either live or die on the strength of the faithful remnant, as Benedict XVI called them.
A good friend of mine was able to cross the BC border by car for some business matters he has in America. From secondhand information, its supposed to be easier to get into America than it is to return to Canada.
It's a city full of subservient Asians, wokes, and liberals. Wouldn't be surprised if it's close to the actual number.
There are pros and cons to married priests. The Roman church (most of Catholicism) only holds priestly celibacy to be discipline and can change it. One of the largest cons to priestly celibacy is the hiding of gays in the priesthood, as you mentioned. But between the vocations crisis generally, and the amount of divided priorities a married priest has (family vs parish, marital relations vs Divine Liturgy, availability), I don't think it's wise for Rome to change its discipline. An increase of clerical Brothers and Deacons would definitely help offset the day-to-day minutiae and allow the priest to focus on holiness but we're far from that point. The key here would not be to admit so many gays to seminary but since the hierarchy of the Church is already compromised, it's not going to happen (and reform won't follow) for a few generations.