I don't see the problem with Worf as the captain of the Enterprise. Every Enterprise had a human caucasian male or female as the captain. Having an alien as the captain of the Enterprise would show the diversity of Starfleet.
Not against an alien captain in general, just Worf in specific. The character has bee so overused that I'm sick of him.
But in the current TNG storyline, Worf makes sense to be the next captain.
Then kill him off.