I've used super glue as a finish and others seem to have used for a long time with good results. However, I put it on whilt still on the lathe to get a friction finish. Don't know how it would work with the piece stationary.
Any finish will wear off over time. The issues that need to be addressed are more about liquids seeping through the pores in the wood. For vessels, I would use tight-grained woods. Film finishes will wear off. Super glue forms a film, but it is so thin that it will penetrate into the open pores too. Surface material will wear out, though. Also, super glue releases with heat. Might not be a good option. Oils penetrate, but also will wear out and/or dry out over time. General makes a salad bowl finish touted as food safe. But just to be clear: ALL FINISHES ARE FOOD SAFE IF THEY ARE ALLOWED TO FULLY CURE. Varnish, lacquers, oils, everything. Fully cured means that the toxic driers have all cured or evaporated. You should let the finish sit for 30 days to insure fully cured.
For food contact vessels, I just use walnut oil or mineral oil and apply repeatedly as the piece looks dried out.
I just returned from Japan and they have been using Urushi natural lacquer finish for tea cups and soup bowls, plates etc. for over a thousand years. My wife has some we have been using for 35 year that still look as good as new.
CAUTION!!! This is not an easy finish to apply and is from a plant in the poison Ivy family which many people are allergic to during the application process.