The pleonastic use of “sit up” gives emphasis to the fact that what was said was absurd or incredible.

1

1904.  A lady from Boston was there, and she sat up and said that she had not met a single individual in the South who did not talk like a negro.—W. N. Harben, ‘The Georgians,’ p. 209.

2