print (df)
               Name
0  Miss Hello World
1         Mr. Idiot
2  Ms. Good Morning

df['Name'] = df['Name'].str.split(n=1).str[1]

print (df)
           Name
0   Hello World
1         Idiot
2  Good Morning