There is (and always will be) a continual battle for bragging rights in phones... Some people will always feel that they need to have the absolute best in a category.. and the demonstration of the S9 camera at launch taking photos in the dark was spectacular.
So, anyone who needs the latest and greatest, will have a fun 6 months with the s9 until the note9s updated camera beats it.
Anyone who just needs a very, very good camera will still be happy with the Pixel2, S8, S9, or even whatever LG are doing these days .....)