Not even close.
First of all neuro-trauma (decompressive craniotomies, craniectomies and cauda-equina decompression) will always exist.
Aneurysms- true the majority are becoming coiled vs. open clipping, but Neurosurgery has taken over the field of endovascular intervention. Now you have to be a neurosurgeon in order to do endovascular interventions. Also, not all lesions can be coiled (shape, dome vs. fusiform, size, calcification/stiffness and location) are always considerations to factor. There are still many aneurysms that require open clipping. Also the new pipeline stents are associated with risk of thrombosis so it will be interesting to see what the new data shows with this regards. That is, whether or not these flow diverting stents will become the standard of care for supraclinoid ICA aneurysms in the future.
AVMs- standard of care is surgical resection. You can pre-op embolize before the operation but YOU DO NOT coil avms
The spine procedures that you are referring to (kyphoplasty/ vertebroplasty) are only indicated for metastatic lesions or patients that have contraindications for surgery. These procedures are not considered standard of care , nor will they ever be. Fusions/lamis (bread and butter of spine) will always exist.
Cancer- These new immunotherapies that you speak of, such as DC-VAX are only administered in conjunction with the standard of care for current treatments. IE DC-VAX for treatment of GBM. Surgical resection+radiation+ temodar is the current standard. DC-VAX is being administered as adjunctive therapy. Even though initial DC-VAX results were considered encouraging before phase III, new and recent data is not as encouraging. The blood brain barrier will always be a problem for drug delivery into the brain, even though chemo can be administered intrathecally, these procedures/administrations are usually used in palliative/ late stage treatment. Radiotherapy, Gamma knife are always used either in conjunction with surgical resection or as a late stage alternative for palliative care. Also consider that a neurosurgeon MUST be involved in RAD ONC planning for treatment of tumors. For gamma knife, a neurosurgeon must be present to bolt on the frame and they are usually involved with the mapping/planning portion of the procedure.
Neurosurgery will always exist.