Yes, as soon as people stop using search engines, which may be never, so on second thoughts, no, never. As long as people are using search engines to answer questions, SEO will be there to help websites craft answers to them.