Sparrows are history these days, but even more modern weapons can be defeated. It’s a lot about knowing what your weapon’s perf envelope is, and what the other side has to throw at you, and defending appropriately.

You could watch some of these DCS dogfighting videos, there is a mixture of guns only or short range missiles.

https://www.youtube.com/c/GrowlingSidewinder/videos

Here is one where the flightsim pilot dogfights a French Rafale pilot. https://www.youtube.com/watch?v=zgDZ4BLk0Pw

That's not fun, you just do dogfighting with cannons and/or shortrange IR-Missiles, like in that "AI" Sim.