Welcome to RootsChat Arthursgirl

Do you also have the 1891 census? Benjamin's name is down as Rhodes, while John is Moody:
1891RG12/4052 96 22
Stockton, Durham
23 Union StreetJohn Moody, head, 32, Mar Engine Fitter, b. Hartlepool
Elizabeth, wife, 31, b. Stockton
Fanny, dau, 2, b. Stockton
John, son, 5, scholar, b. do.
Amy Rhodes, niece, 10, scholar, b. do.
Benny Rhodes, nephew, 8, scholar, b. do.
Niece and nephew - euphemisms for stepchildren?
The different status for John and Benny would suggest that John was John Moody's son indeed while Ben wasn't.
I suppose this is the birth you have found for him:
John William M Rhodes - Jun 1886 - Hartlepool 10a 130
The birth cert will probably reveal that the M stands for Moody but it's not likely to actually show John Moody as the father.
