I have flown LH947 many times, although more recently it has been operated by BMI. Never cancelled in my experience; usually fairly full, especially with people clearly transferring to other flights in Frankfurt.
Will be very happy when the flight returns to being operated by Lufthansa and not BMI. I know a lot of people like BMI but I have had several experiences of poor customer service and no experience of great customer service. Just a lot of rules and being shouted at.