MySQL is FOSS. Moreover, Ghost has a small development team, and maintaining Ghost for multiple databases is a costly endeavour.
Resources are used to introduce new features. However, since Ghost is open source, you are free to modify the code to support another database.