There is no objective answer to this question. Fame is subjective, comprehensive birth records for all "famous" people don't exist, and criteria vary wildly by era and field.
Anecdotally, October is sometimes cited due to post-holiday conception peaks, but this is purely speculative. No month holds a verified crown.