You do NOT need Xbox Live Gold to play Fallout 3: Game of the Year Edition offline.
Install to HDD (Y button on game → Install). Reduces load times, laser wear, disc noise. ~6.8 GB.
Enjoy the Wasteland offline. No subscription needed.