No, you do not need Xbox Live to play Burnout Paradise.
Burnout Paradise is a single-player game playable offline without internet or Xbox Live subscription.
Online Features Requiring Xbox Live Gold:
Enjoy the full single-player experience without any subscription.