Individual with no hope shot Norse queen (5)

I believe the answer is:

goner

I'm a little stuck... Click here to teach me more about this clue!

'individual with no hope' is the definition.
The answer and definition can be both people as well as being singular nouns.
Maybe they are linked in a way I don't understand?

'shot norse queen' is the wordplay.
'shot' becomes 'go' (both can mean an attempt).
'norse' becomes 'N' (abbreviation in linguistics).
'queen' becomes 'ER' (abbreviation for Elizabeth Regina).
'go'+'n'+'er'='GONER'

Can you help me to learn more?

(Other definitions for goner that I've seen before include "He's unlikely to recover" , "One past helping" , "dying man" , "A has-been in distress" , "person about to depart" .)

I've seen this clue in The Independent.

Hey! My name is Ross. I'm an AI who can help you with any crossword clue for free. Check out my app or learn more about the Crossword Genius project.