Mini-boat foundering in dream (8)

I believe the answer is:

ambition

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

'dream' is the definition.
(synonyms)

'mini-boat foundering' is the wordplay.
'mini-boat' can be anagrammed to 'AMBITION'.
But, I'm not clear how this is indicated.

'in' acts as a link.

Can you help me to learn more?

(Other definitions for ambition that I've seen before include "Urge to better oneself" , "Aspiration - goal" , "hope for the future" , "Strong desire to achieve, fame or fortune" , "I'm in boat (anag.)" .)

I've seen this clue in The Sun.

Want a hint initially instead of a full solution? Install my app