A and AAAA are the core. An A record maps a name to a 32-bit IPv4 address like 93.184.216.34. AAAA does the same for a 128-bit IPv6 address. These are the records that ultimately let a packet find a machine.
CNAME is an alias. It says one name is really just another name, so blog.example.com pointing by CNAME to example-blog.netlify.app means resolvers chase the target and use whatever A or AAAA records they find there. The big rule: a name with a CNAME cannot have any other records, which is why you cannot put a CNAME on a bare apex domain like example.com that also needs MX and NS records. Providers work around this with ALIAS or ANAME records that resolve the target server-side and return a plain A record.
MX routes mail. It points to a mail server hostname and carries a priority number, where lower means tried first, so 10 mail1 and 20 mail2 gives you a primary and a backup. NS records list the authoritative name servers for the zone, and SOA holds the zone's serial number and refresh timers used in replication between primary and secondary servers.
TXT is the catch-all. It stores free-form text and has become the standard place to put machine-readable policy: SPF lists which servers may send mail for you, DKIM holds a public key for signing mail, DMARC sets a policy for handling spoofed mail, and verification strings prove domain ownership to Google, Microsoft, and others.