No. You only need Xbox Live Gold (now Game Pass Core) for:
The Xbox 360 Store ceased new purchases July 29, 2024. You can still download previously owned content, but cannot buy new games/DLC on the console. Use xbox.com/games/store on PC/phone to purchase backward-compatible titles for 360.