Kiwi, your dream is indeed quite vivid and multifaceted, reflecting various aspects of your subconscious mind. The presence of your friends and family in your dream suggests a deep-seated connection and reliance on your close relationships, even if in waking life you feel isolated or single. The act of your best friend picking you up in a car, something he does not possess in reality, may symbolize a desire for support and mobility in your life, possibly indicating a wish for someone to 'drive' you through challenging times or transitions.
The self-piercing in the car is a striking image. This could represent a form of self-expression and transformation, as piercings often are symbolic of personal change and identity. Doing this in a car, a place of movement and transition, suggests that you are undergoing or wish to undergo significant changes while on your journey, despite the unconventional or risky environment.
Arriving at an unknown house in a familiar neighborhood from previous dreams points to recurring themes or issues in your life that you are yet to fully resolve or understand. The rich family with three boys whom you've never met could symbolize societal pressures or ideals that you feel are foreign to you but still impactful. The fusion of your Papa and older cousin into a single entity represents a blending of different aspects of familial guidance and support, possibly indicating a need for such a figure in your life.
The brief Zathura and Pirates of the Caribbean crossover scene adds to the sense of adventure and unpredictability in your dream, perhaps signifying your subconscious yearning for excitement and escape from the mundane or stressful aspects of your daily life.
Finally, the disturbing image of sores and bleeding wounds on your face, along with the greasy substance turning your hair white, might reflect underlying anxieties about your self-image and health.