I think the "Sky-Active" moniker was chosen to emphasize the environmental benefits to the new engines: better fuel economy, lower CO2, etc., along with decent performance. (Sky=atmosphere, active=go, get it?)
Japanese manufacturers are good at coming up with puzzling English product names. I rate the "Sky-Active" name higher than Honda's new "Earth Dreams" line of GDI engines. Now if Honda's target demographic includes gophers and badgers...