Being in tune means a pitch aligns with a reference standard, creating consonance. Being out of tune means it deviates, causing dissonance or "beating" (a pulsating interference pattern).
Modern tuning standardizes A4 = 440 Hz (concert pitch). All other notes are derived mathematically (equal temperament divides the octave into 12 equal semitones).
"In tune" isn't always absolute. Just intonation (pure ratios) sounds different from equal temperament. Ensemble players constantly micro-adjust for harmonic context. But the fundamental principle remains: alignment = consonance; deviation = dissonance.