It wasn't agreed on because it was not standardized and most importantly, because there were no alternative implementations. SQLite is amazing but accepting a single implementation as standard is a huge dependency. I was very sad to see it getting dropped but it had to be.
It make an enormous amount of existing code available on the web.
It just wasn't agreed to by Firefox because it didn't have enough JS.