Rod Stewart said BBC 'made' him sing Sweet Caroline and it made him uncomfortable