One of the prime motivations for celibacy is the witness value it brings in the modern world. I question how much the average Catholic even cares that their priests are unmarried. I think it matters not a whit to the vast majority of them.
God notices, of course, and that's not a bad audience to play to, but I know, in my case, that I wouldn't have lasted two years in the priesthood had I gone on to ordination, God or not.
It took me several years to get over the idea that I had somehow failed in my life by not becoming a priest. Now, with my family, I wonder how I could have ever thought that.
Of course, the 'vast majority' (approximately 70%) don't believe in the Real Presence and in the most infamous poll ever taken, the 'vast majority' chose Barabas.