The Poison frontman is the latest artist to drop out of the event, which was purportedly pitched as a nonpartisan celebration of America’s 250th anniversary