No, that was his own objection to it. He ridiculed the theory because he (incorrectly) thought that a theory that implied a God was repugnant to science. It turns out that the science won out, however, and now "The Big Bang" is widely accepted, in spite of its implications.
Of course they had disagreements and Hoyle was voicing his opinion on that. Except, as Lemaitre himself said on multiple occasions, the theory didn't imply any god at all. And his colleagues, being physicists and all, knew that. So it is my understanding that the target of this ridicule is the willfully ignorant public.