Yes, Nokia 8110 4G does have the vibration alert.
No. Exactly we cannot say that Nokia 8110 4G is a waterproof device. But it is IP52 certified. Means it is splash proof. You are protected up to some extent by water.
Nokia 8110 4G comes with 512MB RAM and 4GB internal storage. Hence, just like your Android phone, it has phonebook with unlimited storage.
Nokia 8110 4G comes with 512MB RAM and 4GB internal storage. You will get practically unlimited storage for SMS.