SQL Server Express LocalDB is an SQL Server-compatible DB with reduced administrative overhead. Its primary advantage for Orchard development and UI testing is that it doesn't need SQL Server to be properly configured (for HTTP connections) and its service running. However, it still needs SQL Server to be installed. Thus, its utility is limited but let's evaluate whether we can add support for automatically managed LocalDB instances (just as we do with SQL Server DBs).
Jira issue