People who make concrete counter tops use a lot of fibreglass fillers to get them fairly thin but if you wanted it truly light weight you’d probably need to make it out of a dense foam and coat it with something that looks like concrete.
Concrete counter top mixes usually use either much smaller, or no aggregate and use more sand. The mixes resemble mortar more than concrete and they are typically a little harder and less forgiving to work with.
oh wow that takes me back. I remember touring, i think it was Texas A&M, in HS and they showed off their "concrete canoe" to the group. This would have been in the late 1900s.. 1995 or around there.
You could mix concrete with other materiais too. I worked as a lab assistant in a engineering lab for some time. Putting styrofoam into the mix would result in lighter concrete within acceptable levels of resistance (for low level buildings). You might be onto something
There are a lot of additives to concrete - the industry is large and has put a lot of money into research over the decades. You can read many many books on the pros and cons of different options.