It won't work. You are mixing compile-time polymorphism (the element types and count of a tuple) with run-time polymorphism (you want to store differently sized tuples in a container).
In your example, what should container[0].get<2>
return? Tuples are guaranteed to be compile-time checked, so there is no runtime information to check whether 2 is a valid index, so throwing an exception or returning a default constructed object can't happen just from using the tuple.
In your example, you are going to copy or move the tuple (when inserting them into the container) anyway, which means you need to copy or move all the elements. You could instead of copying the tuples elements into (new) tuples copy the tuple elements into std::vectors. The function tuple_to_vector would need some template magic to implement efficiently, which I don't have the time to draft up right now.
If you can change the API to return std::arrays instead of std::tuples (which actually guarantee homogenous type and contiguous storage, and provide run-time indexing), a convert-to-vector function would be quite trivial to write.