Beatrice 'loses all hope' of becoming a working royal