Normal mode theory for the Brownian dynamics of a weakly bending rod: Comparison with Brownian dynamics simulations