Charlotte Church has apologised for making unflattering comments about the Queen - and admitted she had been "foolish" to make the "flippant" remarks.