There are pros and cons to WordPress' database structure. While it may take "a series of SQL gymnastics just to retrieve the relevant data" it's database structure is incredibly resilient to the changing requirements of different users. A "better" database structure would almost certainly be too fragile to meet the needs of as many users as WordPress does.