Strategist says Democrats have to become ‘an effective and smart opposition party, not a bunch of hoo-ha screaming and yelling’