I am here from India on a F1 visa and my wife and son would be here on a F2 visa. Are they required to obtain a social security card once they arrive in U.S.

No.. both F-1 and F-2 are not eligible to obtain SSN.

I'm on F-1 visa and I got SSN!