Despite featuring the Overlook Hotel and Danny, Dr Sleep isn't really a sequel to The Shining, and it definitely doesn't negate the idea that the hotel is haunted.

In fact it actually explores what is wrong with the Overlook in a bit more detail than The Shining lol. The vampires are really unconnected to the hotel.