Here is what I found on my Pixel 2. Apparently the Pie update reset the notification settings on Messages app.
From within the Messages app, select Settings --> Notifications --> Show Notifications
You'll also see options to select sound, show bubble, etc.
Hope that helps!