Compared to six/seven years ago? Quiet, I’m afraid, my friend. Very quiet. You’ll find a lot less random RP in Stormwind than you used to.
That said, the Wyrmrest Community Project has been doing phenomenal work re-invigorating the RP scene. (See them here: Wyrmrest Community Project ) Through them you’ll see that the community is still alive and well, just quieter. There’s events on an almost daily basis in their calendar, and lots of spontaneous random RP, especially in Duskwood interestingly, thanks to a ghostly knight named Thomas. \
I’ve recently been getting back into Alliance RP a little bit and it’s still a fun vibe. I hope you find what you’re looking for. The Wyrmrest Community remains vibrant and fulfilling, despite the decline brought about by successive poorly-received expansions and scandals at Blizzard HQ.