jQuery isn't suited to SPAs (pick any of the awesome FE frameworks for that) but on a normal request/response site, it will get you up and running in no time. Make a table sortable in a one line; what's not to love?
It's also AMAZING for hacking! Let's say I'm on a site and I want to strip out some text, or update something to show a client or colleague something. If jQuery is in the page (or I load it using a Favelet) I can quickly rattle out a one-liner in the console to trawl the DOM and update or scrape.
It's not that you don't get that with ES6 / React / Angular, it's that (the DOM part of) jQuery is all about moving around the DOM and treating elements as chained collections. It's just another paradigm and an incredibly useful one at that.
My only advice would be that as it's so powerful, it's tempting to use it as a crutch, especially when the latest browsers much more powerful selectors and and are generally standardised. If you have jQuery, it's still way quicker to write a one liner than it is to write 10 lines of looping vanilla JS.
Don't let the haters drag you down. Use both as appropriate.